Skip to Content
author's profile photo Former Member
Former Member

Where Condition in Webi

Hi

As per requirement, i created a variable with WHERE condition on it.

Like below,

=[Status] where ([Flag]=1). It produces the result with one empty row. How to get ride of that empty row? I am trying to use this variable in column chart.

Thanks

Hari

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Posted on Aug 10, 2015 at 01:22 PM

    Hi,

    Use this.

    Var=if(isnull([Status] where ([Flag]=1)) or ([Status] where ([Flag]=1)="") then "Hide" else [Status] where ([Flag]=1)


    Apply the report filter and condition is Var not equal to Hide and then turn to chart.


    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 10, 2015 at 01:53 PM

    Why can't you simply apply a block level filter as Flag = 1 ?

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2015 at 06:15 AM

    Dear Hari,

    As per my understanding if your output is fine and you want to remove only empty row then uncheck the option in graph/table properties "Show when row value is empty" or the problem is with where condition please provide some example with snapshot.

    Thanks & Regards,

    Ragoth.C

    Add comment
    10|10000 characters needed characters exceeded