Set analysis problem in chart

Anonymous — Tue, 21 Jun 2016 06:51:48 GMT

Hi Geniuses,

I want to create one chart which will have the value something like below

Month	Sony	Samsung
Jan	5000	6000
Feb	5020	6090
Mar	6000	7000
Apr	6030	7050

now how the 5000 will come in Jan for sony --> it will be the count of records from all the previous years till Jan

now how the 5020 will come in Feb for sony --> it will be the count of records from all the previous years till Jan + count of records of feb

when I am using the set analysis like this in a text box count( distinct{$<YEAR = {">1978<2016"}>} VENDOR_SITE_ID ) and selecting the customer it is giving me the correct count of records of the customer

but when I am putting the same set analysis in the chart above it is not dividing the count as per the clients.

can you please look into this

Thanks in advance

Re: Set analysis problem in chart

sushil353 — Tue, 21 Jun 2016 06:55:22 GMT

Hi,

Can you share a sample data set. ? Ideally it should work if you have added a customer dimension.

topic Set analysis problem in chart in QlikView

Set analysis problem in chart

Re: Set analysis problem in chart

Re: Set analysis problem in chart