topic Re: Dimension in QlikView

Dimension

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi all ..

I have a question..

Please find the attachment of the qvw file..

I have a dimension say Class and expression as sum(Students)

Now in dimension under class i have

1st

2nd

3rd

4th.

now my requirement is i wanted to always diplay all the classes under legends ...

in the current bar chart i have selected 2016 and the legend is shwoing 1,2,3rd class ..i want still under legends all fours classes should be shown...

how can i achive this ?

Thanks in advance

Re: Dimension

Anonymous — Fri, 17 Nov 2017 10:32:08 GMT

Hii John,

In Properties, Presentation tab, uncheck supress zero values

Thanks,

Akash Gaikwad

Re: Dimension

poojashribanger — Fri, 17 Nov 2017 10:39:14 GMT

Hi,

You can go for workaround like take snap shot of all 4 legends and then add inline image.

the from bar chart off show legend.

plz check

Re: Dimension

stabben23 — Fri, 17 Nov 2017 11:12:18 GMT

Hi John,

I'll think this is a vell known issu and also a lot disscussed here on the community.

But try this, sum(Students)+ Avg({1} 0) and these settings in presentation