topic Re: conditional show (sub)column in pivot table in QlikView

conditional show (sub)column in pivot table

curiousfellow — Fri, 18 Mar 2016 11:20:20 GMT

I have created a pivot table with column year and three subcolumns sum(sales),count(articles), sum(credit_sales)

Now I want to display credit_sales only for the highest year.

Because I cannot find a way to hide the column credit_sales for previous years I did a conditional formatting where font color is white for previous years.

Only thing to solve now is how to conditional format the columnheader for credit_sales, could you help me with that ?

Re: conditional show (sub)column in pivot table

Gysbert_Wassenaar — Fri, 18 Mar 2016 11:22:37 GMT

Try something like =if(Year <> max(total Year), argb(0,0,0,0),0)

Re: conditional show (sub)column in pivot table

sunny_talwar — Fri, 18 Mar 2016 11:22:51 GMT

Do you have a sample you can share?

Re: conditional show (sub)column in pivot table

Anonymous — Fri, 18 Mar 2016 11:26:57 GMT

Did you check this?

Using Column Visibility | Qlikview Cookbook

Hiding columns in a pivot table | Qlik Community

Re: conditional show (sub)column in pivot table

curiousfellow — Fri, 18 Mar 2016 12:54:12 GMT

In those examples the subcolumn is shown or hidden for all years, also for the highest year

Re: conditional show (sub)column in pivot table

curiousfellow — Fri, 18 Mar 2016 12:54:59 GMT

This works for the values but not for column headers

Re: conditional show (sub)column in pivot table

Gysbert_Wassenaar — Fri, 18 Mar 2016 12:57:03 GMT

Works for me.