topic Re: Question on using Before in a Pivot table in QlikView

Question on using Before in a Pivot table

Tue, 08 Jul 2014 02:07:15 GMT

When you show % change in a pivot table using before function, the first column always shows a NULL which is irritating. Is there any trick to avoid it?

Re: Question on using Before in a Pivot table

Anonymous — Tue, 08 Jul 2014 02:18:20 GMT

Hi Ram,

Try below,

Sum ([Headcount at Census])/Before(Sum ([Headcount at Census]),0)

Re: Question on using Before in a Pivot table

Tue, 08 Jul 2014 02:28:14 GMT

Sorry Satyadev, it didn't work. Actually under Feb-14 i don't want %change column to appear at all. It doesn't make sense as there is no data available before that.

Re: Question on using Before in a Pivot table

Anonymous — Tue, 08 Jul 2014 02:46:55 GMT

Hiding column in Pivot table with cross table view is really nightmare. You may have to thing some easiest way

What if you can add some text like "NA" or "Not Applicable" Or white the background Or add some text object with white background on top the column.

Re: Question on using Before in a Pivot table

Clever_Anjos — Tue, 08 Jul 2014 03:11:50 GMT

Try adding ALT function around your expression using above

ALT ( yourexpression, 0 )

Re: Question on using Before in a Pivot table

Tue, 08 Jul 2014 04:11:40 GMT

Sorry Clever, not what i am looking for.