topic Re: 30 day count(distinct) every day in QlikView

30 day count(distinct) every day

vmusolov — Sat, 29 Dec 2012 07:06:10 GMT

Tried to build a chart, where every day is how many unduplicated users visited in 30 days including this one.

For example on January 30 = count({date={">=01/01/2012 <=30/01/2012"}}distinct user_id)

It works for 1 day, but i need chart.

Can someone give solution?

Anonymous — Sat, 29 Dec 2012 08:45:10 GMT

Is date your dimension ?

Jonathan

vmusolov — Sat, 29 Dec 2012 09:57:54 GMT

cycle dimention day(date) and day(date)&month(date)

Anonymous — Sun, 30 Dec 2012 23:01:06 GMT

The set analysis needs to be surrounded by <> brackets. You'll also need to use dynamic dates. Try ...

count({<TransDate={'>=$(=Today()-30) <=$(=Today())'}>} distinct user_id)

Jonathan

Mon, 31 Dec 2012 03:21:21 GMT

Hi,

Rangesum and above functions may help. Pls. have a look at the attached example.

Regards,

Anonymous — Mon, 31 Dec 2012 07:34:16 GMT

Actually, I see now that you mean you want roling 30 day results, with the data point for each date being for the 30 days previous to that date.

See this post on Rolling 12 months (http://community.qlik.com/thread/38355). You should be able to apply the same logic to the last 30 days.

Jonathan