topic Re: Pivot Table suppress null values in QlikView

Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 06:54:23 GMT

Hy guys.

I have brought my info into a Pivot Table , in which I made it in more levels. So , I have three level of info.

But in some cases I have two levels or even one level. What I want to do is that when I have two or one level to show only the Info that is on a specific level and to suppress the expansion button if on the lower level I have no data.

Is there any way to realize this option.

Thank you.

Re: Pivot Table suppress null values

mightyqlikers — Mon, 26 Sep 2016 07:02:17 GMT

Hi,

Please share some data and expected output.

$@M.

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 07:09:08 GMT

I don`t have access to the app now , but the table looks like:

Level 1

Level 2

Level 3;

And I have some cases when all three levels are populated with data. But there are other cases when I have to show

Level1

Level 2

Or just Level1.

But when I have just Level1 or level1 and level 2 , the + button is shown for the lower levels. But when I extend it shows null data. What I want is if I don`t have some lower level that + button to be hidden.

Hope this example helps.

Re: Pivot Table suppress null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 07:41:41 GMT

Check from Dimension Tab of your Dim

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 07:46:52 GMT

Nope , that`s not the solution , because when I check that field , it will supress all levels when one of them is null. That`s what I saw.

Re: Pivot Table suppress null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 07:49:15 GMT

Strange, As i explained that is theory. Can you please share the sample application

Because, If you don't have data field value will visible. Then you need to do that option then the field should be hidden.

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 10:23:56 GMT

As you cand see in the image bellow sometimes I have 3 levels sometimes 2 levels sometimes just one level.

What I want is that I would like to hide those null values and when there is no drilldown level the + icon to be disabled.

These are my dimmensions.

When I check suppress when the value is null , for the third level I get this result

All other info that doesn`t have a 3rd level is hidden. I only want to hide the 3rd level when I don`t have it.

Re: Pivot Table suppress null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 10:26:29 GMT

Sorry For that, might i can't help without seen your application.

QlikCommunity Tip: How to get answers to your post?

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 10:28:47 GMT

The problem is that my app contains classified info , so I can`t post it

Re: Pivot Table suppress null values

Anil_Babu_Samineni — Mon, 26 Sep 2016 10:30:56 GMT

Try This way

Scrambling Data

Re: Pivot Table suppress null values

quwok — Mon, 26 Sep 2016 11:28:30 GMT

Have you tried playing with the presentation settings on the Chart Properties > Presentation tab

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 17:24:01 GMT

Hy Kwok , I`ve tryed all the possibilities , nothing works. Hope you guys can figure out what is the solution. I have attached to this comment some sample files in which I replicate the info that I have.

Hope you can help me.

Re: Pivot Table suppress null values

sunny_talwar — Mon, 26 Sep 2016 18:30:42 GMT

Is this the issue that you are still able to expand to Level 3 even

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 18:36:32 GMT

What I want is that I want to expand only to the level where I have data. So when I have 3 level to be able to exand to the 3rd level , when there are only two levels I would like to expand only to the 2nd level , and the 3rd to be disabled.

Re: Pivot Table suppress null values

neelamsaroha157 — Mon, 26 Sep 2016 18:42:45 GMT

Check this out..

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 18:46:24 GMT

Nope , it`s not ok , because I can still expand to level 3 when there is null value. I would like to suppress the expansion button when on an inferior level I have null data.

Thank you

Re: Pivot Table suppress null values

sunny_talwar — Mon, 26 Sep 2016 18:55:19 GMT

Unfortunately this functionality is not available within the inbuilt capabilities of QlikView. There might be some macros, but I am not aware of them.

Re: Pivot Table suppress null values

razvan_brais — Mon, 26 Sep 2016 18:58:23 GMT

In programming there is allways a way to do something I will try all possibilities I can , and if I will find the solution I will come back with an answer. But if anyone knows a way to achive this please let me know.

Thanks a lot.

Re: Pivot Table suppress null values

sunny_talwar — Mon, 26 Sep 2016 19:01:19 GMT

I like your spirit my friend and I hope you do find a solution and come back to us with it.

Best,

Sunny