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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

Exclude selections

Hi Guru's,

I am using runtime expression ,here i am unable to stop selections of my time filters ,After removing min and max date condition it is working fine when I add min and max date condition it is not working it means ,if I select quater the chart is chaging to quater data .I don't want like that if i use  runtime calculation also it should stop time filter selections.

count(distinct {<Date={">=$(=min(Date)) <=$(=max(Date))"},Year=

,Quarter=,Month=>}id)

/

count(distinct {<Year=,Quarter=,Month=>}id)

Thanks,

Sateesh

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

Try:

count(distinct {<Date={">=$(=min({1}Date)) <=$(=max({1}Date))"},Year=

,Quarter=,Month=>}id)

/

count(distinct {<Year=,Quarter=,Month=>}id)

View solution in original post

1 Reply
shraddha_g
Partner - Master III
Partner - Master III

Try:

count(distinct {<Date={">=$(=min({1}Date)) <=$(=max({1}Date))"},Year=

,Quarter=,Month=>}id)

/

count(distinct {<Year=,Quarter=,Month=>}id)