topic Re: Re: Show only certain values in Straight table in QlikView

Show only certain values in Straight table

Thu, 28 Aug 2014 11:40:26 GMT

Hi,

I have a table that calculates A,B,C values in one column. I want to create 3 different tables and in those tables to show only the corresponding values like in table 1 i want to show A values, in table 2 B values and in table 3 - C values. How can i achieve it? The ABC field is an expression.

Re: Show only certain values in Straight table

PrashantSangle — Thu, 28 Aug 2014 11:44:46 GMT

Hi,

If it is your dimension

then write calulated Dimension as

if(Wildmatch(fieldName='A'),FieldName)

and tick on Supress Null in Dimension tab

If it is your expression through which you are calculating A,B and C

Then Write in Expression

IF(Expression='A',Expression)

and Tick on Supress Null values in presention Tab.

Regards

Re: Show only certain values in Straight table

Thu, 28 Aug 2014 11:51:51 GMT

Hi,

It is expression. I have already tried F(Expression='A',Expression) and checked supress Null values but it simply doesn't supress.

Re: Show only certain values in Straight table

PrashantSangle — Thu, 28 Aug 2014 11:56:51 GMT

Hi,

Basically If you have only that expression then this should work,

If you have some more expression except that expression then,

For every expression you have to write

If(Expression1='A',Evalute Expression2)

Then it will give you - symbol and Then Supress Zero and Supress Missing Should work.

If still not understand the logic then provide me sample file, I will do it for you.

Regards,

Re: Re: Show only certain values in Straight table

Thu, 28 Aug 2014 12:15:19 GMT

Hi,

This is my example: