topic Re: Pivot table some problem,Who can help? in QlikView

Pivot table some problem,Who can help?

maxloveiii — Mon, 05 May 2014 05:04:19 GMT

I have problems in pivot table.

My data like a sample file was attached and I figure it below.

I need to hide some expression in first dimension( Value = All), hide null dimension, Show all period(Jan - Dec) Year 2014( Apr- Dec) not yet data and add total average in right of table.

Re: Pivot table some problem,Who can help?

Mon, 05 May 2014 09:48:41 GMT

Hi,

Edit the 1st Dimension and add this as calculated dimension.

=if(ItemName='All',Null(),ItemName)

And check the option ' Supress When value is Null' in Dimension Tab.

Thanks,

Prabhu

Re: Pivot table some problem,Who can help?

maxloveiii — Mon, 05 May 2014 10:24:06 GMT

Hi Prabhu, Thanks a lot for reply.

Your solution hide all row in 1st dimension(='All') but I would like to show 1st dimension(=All) with expression 'Case' and 'Amount' only and 1st dimension(='B' or = 'C'), I still would like to show with 4 expression 'Case', 'Amount', '%Case' and '%Amount'.

However, Thank you very much for your reply.

Suphanya

Re: Pivot table some problem,Who can help?

its_anandrjs — Mon, 05 May 2014 10:36:42 GMT

For First dimension try to write like

=if( Len(ItemName)>0,ItemName)

Re: Pivot table some problem,Who can help?

sudeepkm — Mon, 05 May 2014 11:23:09 GMT

The text can be hidden instead of the complete expression. Please take a look at the example.

One quick question do you want to show all months even if there are no data (example year 2014 does not have all the months)