Pivot Table suppress null values

[razvan_brais]

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.

[quwok]

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

[razvan_brais]

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.

[sunny_talwar]

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

[razvan_brais]

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.

[neelamsaroha157]

Check this out..

[razvan_brais]

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

[sunny_talwar]

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

[razvan_brais]

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.

[sunny_talwar]

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

Best,

Sunny