30 day count(distinct) every day - Qlik Community

vmusolov · ‎2012-12-29

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 · ‎2012-12-29

Is date your dimension ?

Jonathan

vmusolov · ‎2012-12-29

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

Anonymous · ‎2012-12-30

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

Report Inappropriate Content · ‎2012-12-30

Hi,

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

Regards,

Anonymous · ‎2012-12-31

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