Skip to main content
Announcements
Join us on Sept. 17 to hear how our new GenAI Assistant empowers data professionals: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MOHTASIM
Partner - Contributor
Partner - Contributor

Remove Date Filter Interaction for Graphs

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).

Labels (1)
3 Replies
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
MOHTASIM
Partner - Contributor
Partner - Contributor
Author

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).

Anil_Babu_Samineni

Sample Qlik Sense Application?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful