topic Re: pivot table question in QlikView

pivot table question

Thu, 23 Jan 2014 20:48:22 GMT

How can I get rid of the empty rows where level 2 and level 3 is empty but i still want to show if there is a level1 or level2

Re: pivot table question

Anonymous — Thu, 23 Jan 2014 20:55:49 GMT

Guessing: if Level 2 is empty, Level 3 is empty too (?). Try to "suppress when value is null" for Level 2.

Re: pivot table question

Thu, 23 Jan 2014 21:13:57 GMT

if i suppress level2 than the one level1 goes away for ana6

Re: pivot table question

Anonymous — Thu, 23 Jan 2014 21:21:21 GMT

Oh, you want to keep it? I got your request wrong... Probably could be done on the expression level, or calculated dimension. Need some thinking to do, but not now.

I bet someone will answer before I get back to it 🙂

Edit: actually, got an idea for you to play with - see attached.