topic Re: Multiple Dimensions on Bar Chart in QlikView

Multiple Dimensions on Bar Chart

triekong — Thu, 23 Nov 2017 05:18:23 GMT

i have created a bar chart with 2 dimensions. but for some reason, QLIK is displaying some bars with different spacing between them

what am i doing wrong?

dimensions: questions & category

expression: questions score

i have attached the picture and the QV file as well

Re: Multiple Dimensions on Bar Chart

Anil_Babu_Samineni — Thu, 23 Nov 2017 05:20:39 GMT

May be null values are there. Can you suppress once

Re: Multiple Dimensions on Bar Chart

triekong — Thu, 23 Nov 2017 05:24:12 GMT

thanks for the response. No nulls are present in the dataset. but i have suppressed them anyway, and still get the same issue

Re: Multiple Dimensions on Bar Chart

Anil_Babu_Samineni — Thu, 23 Nov 2017 05:30:37 GMT

I don't have environment to open your app. Limits are very low. May be some one can offer with your app. as ref.

Re: Multiple Dimensions on Bar Chart

avinashelite — Thu, 23 Nov 2017 06:11:12 GMT

ts a know issue when your using 2 dimensions in bar chart ....Ideal it should thread the second dimension null/missing values as null and suppress them but it won't work. In order to achieve this you need to populate the missing data and then populate the 0 values for those so that it will get eliminated

Hope this helps you