topic Re: How to hide rows of pivot table based on condition. in QlikView

How to hide rows of pivot table based on condition.

Mon, 08 Jun 2015 07:55:48 GMT

Hi All,

I have data like below

I wan to create a pivot table like below when FLAG=1. but this condition I want to use in UI level not in Script level.

(Because I have other object which needs to have total data)

Resulted - pivot: (Note: here in list box I selected 1 as Flag so that result is correct. but I don't want to do like this. by default Pivot need to be displayed like below without selecting Flag=1 in List Box)

You can check this pic in WORD file plz.

I have attached sample data and Qvw file. please help and attach the resulred qvw to the reply.

Thanks,

Kqv

Re: How to hide rows of pivot table based on condition.

anbu1984 — Mon, 08 Jun 2015 15:26:06 GMT

Use this expr

=If(Flag=1,Flag)

Re: How to hide rows of pivot table based on condition.

santhoo_san — Mon, 08 Jun 2015 15:26:09 GMT

create expression if (flag=1,1,0) and suppress zero values in presentation tab

Re: How to hide rows of pivot table based on condition.

Tue, 09 Jun 2015 13:39:41 GMT

Hi Santhosh & Anbu Chelian,

I want to use the condition on Dimensions not on Expression level.

Like I wanna write add Calc-dim, based on that only I wanna hide rows which are having 1 as FLAG and that I don't wanna show FLAG-Field in Table at all.

Can you try on this case please....

Thanks,

Kqv

Re: How to hide rows of pivot table based on condition.

Tue, 09 Jun 2015 13:42:54 GMT

Hi Anbu Chelian,

I want to use the condition on Dimensions not on Expression level.

Like I wanna write add Calc-dim, based on that only I wanna hide rows which are having 1 as FLAG and that too I don't wanna show FLAG-Field in Table at all.

Can you try on this case please....

Thanks,

Kqv

Re: How to hide rows of pivot table based on condition.

santhoo_san — Tue, 09 Jun 2015 13:48:41 GMT

Hi Kiran,

you can use if(Flag=1,Name) and suppress when value is null in the dimension.

To eliminate flag 1, use if(Flag<>1,Name) and suppress when value is null in the dimension.

Re: How to hide rows of pivot table based on condition.

Wed, 10 Jun 2015 08:12:43 GMT

Hi Santhosh,

if the Name-Field is having NULL values though flag=1. Then in this case we are loosing required record right.

(to get below table you can remove values of first two fields from the source-file)

In the above example we can see that Flag=1 row has Name as Null values, if we apply we will loose record(s).

So I don't wanna lost any records because having NULL values for any field(s) for FLAG=1.

Thanks,

Kqv