Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
yanivvl0
Contributor III

How to show 4 expressions in 2 lines using subtype stacked ?

hello everybody ,

we ha a bar chart with 2 expressions : brutto , netto and dim year ,  subtype=stacked ,  look like :

bar 1 stnd.PNG

we need to show  brutto , netto  in 2 different calculations that give us 4 expressions ,  so there is a line for each  , something like this :

bar 2 stnd.PNG

i am sure there is awy to do it , can you help ?  thanks!!

1 Solution

Accepted Solutions
adamdavi3s
Honored Contributor

Re: How to show 2 expressions in 2 lines using subtype stacked ?

Awesome, it is much easier to work with data that makes sense

Does this work for you?

View solution in original post

9 Replies

Re: How to show 2 expressions in 2 lines using subtype stacked ?

You can try combo chart with one expression is bar and one more is line. Or else if you are referring different then use style is static instead of group

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
adamdavi3s
Honored Contributor

Re: How to show 2 expressions in 2 lines using subtype stacked ?

Like this?

Capture.PNG

yanivvl0
Contributor III

Re: How to show 2 expressions in 2 lines using subtype stacked ?

hi Adam , not exactly , because i have only one dimension , and to be more cleare 4 ( not 2 ) expressions , brutto , netto calc type 1 and brutto , netto calc type 2.    sorry for not writing this before.

adamdavi3s
Honored Contributor

Re: How to show 2 expressions in 2 lines using subtype stacked ?

hmmmm can you share some simple data in excel or a qvw? sorry my brain isn't up to speed today!

adamdavi3s
Honored Contributor

Re: How to show 2 expressions in 2 lines using subtype stacked ?

Did you manage to solve this one?

yanivvl0
Contributor III

Re: How to show 2 expressions in 2 lines using subtype stacked ?

hi , here an example of 1 dim and 4 expr ,

i need brutto_1 & netto_1 stacked in one line , and brutto_2 & netto_2 stacked in anothet line ,

thanks !

adamdavi3s
Honored Contributor

Re: How to show 2 expressions in 2 lines using subtype stacked ?

Awesome, it is much easier to work with data that makes sense

Does this work for you?

View solution in original post

yanivvl0
Contributor III

Re: How to show 2 expressions in 2 lines using subtype stacked ?

great help Adam - thanks !!

adamdavi3s
Honored Contributor

Re: How to show 2 expressions in 2 lines using subtype stacked ?

No worries at all

If your real world data is more complicated then use Pick(match()) instead of IF as it will work faster, but in this case it will work.