topic Re: 100% Stacked Line graph in QlikView

100% Stacked Line graph

Tue, 10 Jun 2014 11:06:19 GMT

Hello,

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?)

MK_QSL — Tue, 10 Jun 2014 11:14:08 GMT

Can you provide sample file pls?

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

Tue, 10 Jun 2014 11:25:24 GMT

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 dimension

Fri, 29 May 2015 14:18:51 GMT

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

Thanks,

Joakim