topic Re: Stacked Chart in QlikView

Stacked Chart

Mon, 27 Apr 2015 12:23:20 GMT

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

Re: Stacked Chart

prma7799 — Mon, 27 Apr 2015 12:25:43 GMT

Can you please share some sample data.

Thanks

Re: Stacked Chart

Mon, 27 Apr 2015 12:39:17 GMT

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

Re: Stacked Chart

prma7799 — Mon, 27 Apr 2015 12:43:11 GMT

Please send your qvw file.

Re: Stacked Chart

Mon, 27 Apr 2015 12:55:23 GMT

Qlik view attached

Re: Stacked Chart

Mon, 27 Apr 2015 12:57:38 GMT

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

Re: Stacked Chart

Mon, 27 Apr 2015 13:00:18 GMT

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

Re: Stacked Chart

ankitaag — Mon, 27 Apr 2015 13:05:00 GMT

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

Re: Stacked Chart

Mon, 27 Apr 2015 13:31:50 GMT

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?