topic show / hide column with condition in pivot table in QlikView

show / hide column with condition in pivot table

Sat, 17 Jan 2015 12:34:07 GMT

I want to show my result same as Fig1 instead of Fig2

is there any solution?

Fig1:

Fig2:

i want to show Count_No , Only in 2012

and not shown in other years.

thank you

Re: show / hide column with condition in pivot table

sunny_talwar — Sat, 17 Jan 2015 12:43:10 GMT

The only way I can think of is to create field in the script using group by statement and then using it in the pivot table as a dimension instead of an expression.

Best,

Re: show / hide column with condition in pivot table

Sat, 17 Jan 2015 12:46:31 GMT

could you help me to do this?

I can't do it myself

thanks a lot

Re: show / hide column with condition in pivot table

israrkhan — Sat, 17 Jan 2015 12:49:42 GMT

can you please share a sample document,

will be easy to help you...

Re: show / hide column with condition in pivot table

sunny_talwar — Sat, 17 Jan 2015 12:51:06 GMT

I just realized that you already have count as a field name and also did not see the last part where you need the sum for only 2012. I am working with your qvw file to figure out a solution.

Best,

Re: show / hide column with condition in pivot table

Sat, 17 Jan 2015 12:53:11 GMT

I attached a sample file and data file(XLS) in post 1.

tnx

Re: show / hide column with condition in pivot table

Peter_Cammaert — Mon, 19 Jan 2015 08:50:11 GMT

Is this OK?

I'm sure it can be done with a ValuieList() dimension as well. Then you won't need the extra INLINE table.

Good luck,

Peter