Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

100% Stacked Line graph

Hello,

I wanna create a 100% stacked line graph like in this : How to create a "100 % Stacked Column Excel Chart" in QV

But I dont know how to do it with my expression.

I have these 3 expressions:

=count({<GroupingBuyers={'One'}>} DISTINCT CookieIDINT)

=count({<GroupingBuyers={'Two'}>} DISTINCT CookieIDINT)

=count({<GroupingBuyers={'Repeat'}>} DISTINCT CookieIDINT)

Dimension is Week (Could maybe also be GroupingBuyers?)

Tags (4)
1 Solution

Accepted Solutions
Not applicable

Re: 100% Stacked Line graph

I figured out how to do it.

Sliced it on the dimensions, removed my filter in the expression and added a total. So my expression looks like this now:

=count(DISTINCT CookieIDINT) / count(Total <Month> DISTINCT  CookieIDINT)

Added groupingbuyers as dimensionCapture.PNG.png

3 Replies

Re: 100% Stacked Line graph

Can you provide sample file pls?

I don't think so Stacked Line Chart is possible !

Not applicable

Re: 100% Stacked Line graph

I figured out how to do it.

Sliced it on the dimensions, removed my filter in the expression and added a total. So my expression looks like this now:

=count(DISTINCT CookieIDINT) / count(Total <Month> DISTINCT  CookieIDINT)

Added groupingbuyers as dimensionCapture.PNG.png

Not applicable

Re: 100% Stacked Line graph

Hi Thomas! Can you attach a file with your solution?

Thanks,

Joakim

Community Browser