calculate last 3 months hits count

[lakshmittpd]

Hi,

I created an application in which I need to show on first glance show only last 3 months count of users and upon month selection it should change accordingly.

[Channa · Accepted solution]

we dont have onopen filter in qliksense you can try extinctions

try some thing like below

if (Count(Month)>1 ,Sum({$<[date]={">=$(=MonthStart(Today(),-3))<$(=monthend(Today(),0))"}>}Sales), sum(sales))