Stacked Chart

[#1]

Stack Chart

As u can see in the attachment that there are 4 stack for each bar .

I have 4 expression , and one dimension.

My Requirement is I want stak bar only for Members CY and LY and one more

stak bar for Non Members CY and LY . How do i achieve this ?

Is there any way by creating Add Dimension ?

Thanks

[prma7799]

Can you please share some sample data.

Thanks

PM

[#3]

please find my attachment already i got the stack bar with 4 expression and one dimension .

But i need to have two stacked bar one for Members Cy and LY and  second bar with stacked Non-members Cy and LY

[prma7799]

Please send your qvw file.

[#5]

Qlik view attached

[#6]

Hi,

You need to add field containing Member and Non Member as second dimension. In expression you just need one expression for Last Year and one for current year. This should give you the stacked bars in you desired manner.

Hope this helps!

Regards

Sana

[#7]

Thanks for the reply sana , But honestly to tell you iam not  getting this

Do i need to add a variable or what ? in the above conversation i have attached my qlikview file , please find the attachment .

Thanks

[ankitaag · Accepted solution]

Hi,

I am not sure if it is possible as you cannot tell QV or write a condition in chart that not to include this expression in stacked bar or create another stacked bar for those 2 expressions

[#9]

Hi. Was trying to understand your qvw file. Could you tell me how to identify from the booking fact table whether a customer is a member or non member?