topic Re: Hide Pivot Table Row Based On Dimension in QlikView

Hide Pivot Table Row Based On Dimension

Thu, 09 Oct 2014 09:49:59 GMT

Hi All,

In a pivot table I have I have three dimensions City, College, University and one expression Major. Everything fits fine except there rows for each parent dimension where one of the dimension(College) has blank or null. If supress null value is chosen for college dimension the blank or null field still remains.

Is there a condition I can use to remove such rows?

Thank you so much for your time!

Re: Hide Pivot Table Row Based On Dimension

ecolomer — Thu, 09 Oct 2014 09:53:27 GMT

Here you have some examples

Re: Hide Pivot Table Row Based On Dimension

vikasmahajan — Thu, 09 Oct 2014 10:08:35 GMT

pfa sample

Vikas

Re: Hide Pivot Table Row Based On Dimension

Thu, 09 Oct 2014 10:11:21 GMT

HI Enrique thanks a lot for such a quick help. But my use case is to hide those rows where one of the dimesion has no value in it. Can I write a conditional if statement somewhere in this pivot table that would say don't give me those rows where the column for dimension College(in above snapshot) has no value?

Re: Hide Pivot Table Row Based On Dimension

ecolomer — Thu, 09 Oct 2014 10:16:20 GMT

You can use this examples for your problem

You can see the actions on the buton and see the expression

Re: Hide Pivot Table Row Based On Dimension

Thu, 09 Oct 2014 19:53:49 GMT

Thanks to both of you for your help.

I used calculated dimension instead to remove such row where both the dimensions have null value but now i have a new issue.

Here's my calculated dimension, the first dimension (please note that the field Table2.Name and Table3.Name is being used as second and third dimension.)

=IF(ISNULL(Table2.Name) AND ISNULL(Table3.Name),NULL(),Table1.Name)

After selecting "Suppress When Value is Null" for the first dimension, it removes all the rows where both the fields Table2.Name and Table3.Name is null.

However, the problem is now I am unable to select the Table1.Name in the Pivot Chart.

If I use AGGR as following the rows where Table2.Name and Table3.Name are null reappears which is what I don't need either.

Aggr(IF(ISNULL(Table2.Name) AND ISNULL(table3.Name),NULL(),Table1.Name),Table1.Name)

Is there a workaround for this?

Re: Hide Pivot Table Row Based On Dimension

Anonymous — Fri, 10 Oct 2014 02:02:36 GMT

Hi ,

Can you share sample QVW of your issue.

Regards,

Chinna

Re: Hide Pivot Table Row Based On Dimension

sunilkumarqv — Fri, 10 Oct 2014 04:31:09 GMT

Hi,

check the attached file and modify the expression according to your reqiurment

Re: Hide Pivot Table Row Based On Dimension

Fri, 10 Oct 2014 17:45:31 GMT

Thank you all for such great help! Eventually this is what worked for me:

I used calculated dimension instead.

Here's my calculated dimension, the first dimension (please note that the field Table2.Name and Table3.Name is being used as second and third dimension.)

=IF(ISNULL(Table2.Name) AND ISNULL(Table3.Name),NULL(),Table1.Name)

After selecting "Suppress When Value is Null" for the first dimension, it removes all the rows where both the fields Table2.Name and Table3.Name is null.

Re: Hide Pivot Table Row Based On Dimension

agni_gold — Sun, 24 May 2015 19:33:05 GMT

it is not working form me , i have same situation like u , i have tried your way ,