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: 
Louis1
Contributor II
Contributor II

Master dimension will change if variable is changed

Hi all,

i have created a master dimension with below expression:

 

=if(
(
((OpenDate<'$(vReportStartDate)' and isnull(CloseDate)) or (OpenDate<'$(vReportStartDate)' and CloseDate > '$(vReportEndDate)')) and
((OpenDate<'$(vCompareStartDate)' and isnull(CloseDate)) or (OpenDate<'$(vCompareStartDate)' and CloseDate > '$(vCompareEndDate)'))
),'Y','N')

 

if i selected 'Y' and then change the variables and select 'Y' again, it will show two selected field in selection bar.

Louis1_0-1629441736751.png

 

How to fix it.

 

Best Regards,

Louis

 

0 Replies