Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am showing data in line chart with Date as dimension and expression as :
1) Sum({<DATA_DATE={">=$(=(v30Days))<=$(=Max(DATA_DATE))"}>} RECHARGE_SUBS).
2) Sum({<DATA_DATE={"$(=date(today()-2))"}>} RECHARGE_SUBS)
I have multiple charts and requirement is that Date filter should work for some charts while for others it should not filter out or affect them.
so how i can turn off date filter interaction for graphs that are created using above expression (provided on Top).
May be look for alternate states or by expression try this
1) Sum({<DATA_DATE={">=$(=Only({1<DATA_DATE>} v30Days))<=$(=Max({1<DATA_DATE>}DATA_DATE))"}>} RECHARGE_SUBS).
2) Sum({<DATA_DATE={"$(=Only({1<DATA_DATE>} date(today()-2)))"}>} RECHARGE_SUBS)
Thanks Anil but its not working as it start showing all dates for past.So inner date filter gets by pass.
In Variable 'v30Days' i stored today-30 date.(same day last month date.
Graph should show data between v30Days and Max(DATA_DATE).
Sample Qlik Sense Application?