topic Use group & stack in dimension in QlikView

Use group & stack in dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I want to convert bellow's first chart style to the second one:

Separate Sales number and keep Expense number(expensive1, expensive2, expensive3) stack, seems like combine group and stack style.

You can see in my QVW file, I create If function in dimension to filter the category what I want.

The expression is to get the latest data.

However, I didn't find a way to make the chart display the data like the second chart.

Does someone could give me a suggestion to work it out.

Thx...

Re: Use group & stack in dimension

Anil_Babu_Samineni — Tue, 22 Aug 2017 07:57:57 GMT

I assume, Rather creating If condition in UI you can do same in script. And then call them it as ValueList() then look into the Iv condition with ValueList() option to get output

Re: Use group & stack in dimension

vinieme12 — Tue, 22 Aug 2017 08:06:12 GMT

what is the expression for the grey bar?

Re: Use group & stack in dimension

vinieme12 — Tue, 22 Aug 2017 08:09:04 GMT

See attached

Re: Use group & stack in dimension

Tue, 22 Aug 2017 08:22:24 GMT

Hi Vineeth

I adjust the second chart in my original topic, I want to display Sales data in one bar, and display all of the Expense data(expensive1, 2, 3) in another one.

I checked your expression, seems you fix the condition, like '16B Budget Total', but in my actual environment, this field will contain more conditions, like '16B Budget Total, 17A Budget Total, 17B Budget Total' and so on. It will be very complex to write the expression.

I just wonder based on my expression, whether I can create chart like the second style as I pasted.

Re: Use group & stack in dimension

vinieme12 — Tue, 22 Aug 2017 08:25:24 GMT

Can you post a sample that best represents what you are working with?

also can you write the expression for the grey bar?

Re: Use group & stack in dimension

Tue, 22 Aug 2017 08:36:39 GMT

The second chart I didn't work out, so I just use PS for reference.

As bellow's pic, I want to move Sales data outside, not stack all of the expensive and sales data together.

Re: Use group & stack in dimension

Wed, 23 Aug 2017 02:38:58 GMT

I got the solution, just create one table in script to sort type, the chart will separate Sales from Expense.