topic Dimension in QlikView

Dimension

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

Hi All,

Currently i am showing a bar chart with one dimension and one expression .

IN dimension i am showing Category which displays Age,Dept,Sector,Gender totally four bars will appear and expression is sum of expenses.

Now i want to include one more bar in this within category like i want to group altogether and display one more bar as all

so that now the bar chart should 5 categories like ge,Dept,Sector,Gender and ALL.

How can i achieve this within the dimension itself ?

Thanks in Advance

Re: Dimension

Vegar — Sat, 12 Oct 2019 21:55:12 GMT

The easiest solution is probably to remove the category dimension and replace it with 5 measures.

Sum({<Category *={'Age'}>}Expenses)

Sum({<Category *={'Dept'}>}Expenses)

Sum({<Category *={'Sector'}>}Expenses)

Sum({<Category *={'Gender'}>}Expenses)

Sum({<Category *={"*"}>}Expenses)

Re: Dimension

smilingjohn — Sun, 13 Oct 2019 02:38:57 GMT

Vegar,

Thanks for the reply . This is giving me the solution what i wanted . The only problem is the the legends are not appearing below the bars but the legends are showing on the right side chart vertically as shown in the attachment .

How to make the legends appear below the bars ?

Re: Dimension

Vegar — Sun, 13 Oct 2019 06:40:15 GMT

I don't have QV in front of me, but I would look around in the properties tab that are handling styling of the axis.

(You can also remove the dimension from your dimension list if it's still there.)