Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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
MVP
MVP

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