topic Re: How to add more data (not Field) in Dimensions? in QlikView

How to add more data (not Field) in Dimensions?

FabioP — Sat, 16 Nov 2024 02:50:09 GMT

Dearl all,

I have the bar chart bellow with a distribution of quantity of each classification. In my table I'm using the column [Value1] in Dimensions and Count(Value1) in Expressions.
My range is from A to Z but I don't have any values with classification A,B,I,O,Q,S,T,U,V,W,X,Y and Z, and because of this, the letters aren't showing in chart.
I have another column [Class] with letters from A to Z.

I'd like to show all letters even with 0%.

How can I do?

Re: How to add more data (not Field) in Dimensions?

Lisa_P — Fri, 02 Aug 2019 02:02:48 GMT

Rename your Value1 field to Class and it will associate with the Class field and all values will be there in your chart

Re: How to add more data (not Field) in Dimensions?

FabioP — Mon, 05 Aug 2019 13:48:28 GMT

Dind't work... See in attached file what happend when I did what you sugest.
All values was included but was counted as one unit too... I'd like to do this only counting the values from only one of the columns not from both. Including the dimension in the Axes but without couting in the percentage.

Re: How to add more data (not Field) in Dimensions?

BlondeThursday — Mon, 05 Aug 2019 14:04:00 GMT

Perhaps like this?

(please see attached)