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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikofba
Contributor II
Contributor II

Chart displaying all dates when nothing Selected

I have a chart that displays all these dates(prod_dt) that have a month end flag on them(MonthEnd)

I have a dimension of

=if(WildMatch(TrendGroupDesc,'*Retail CD*') and MonthEnd = 1,plan_desc_nm)

and

Prod_dt

and an expression

sum(mtd_avg_bal_amt)

When there is no selection it prints out all of the Prod_dts when the Monthend Flag = 1.  I need to have it so when a prod_dt is selected it prints out the previous 12 prod_dts with the month end flag=1.

1 Reply
Not applicable

can you please share the sample QVW ?