topic Nested Column condition in QlikView

Nested Column condition

Thu, 09 Feb 2012 15:19:43 GMT

Hi All,

I'm just wondering how we can do a condition on nested column of a pivot table.

If you look at the attached file you will see that I have year on the top and nested columns. I want to show the Nb. Cust just for the year 2010 and I want to remove the other Nb. cust of the other years.

Any idea is appreciated.

Thanks

Nested Column condition

hic — Thu, 09 Feb 2012 16:25:32 GMT

Remove the "Show All Values" for the dimension "Year" (Chart Properties - Dimensions). Then the other year columns will disappear when you have selected 2010.

Nested Column condition

Thu, 09 Feb 2012 16:37:28 GMT

Thanks for replying,

What I want to do is that show the report for all years but i want to see "Nb. Cust" just for the year 2010. I tried to do with condition but it did not work.mybe my condition was not good .

Thanks,Nima