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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Micki
Creator
Creator

Ignore field selection in set expression

Hi guys, i have exp.

 

(
(
COUNT(DISTINCT
{<[Week Start]={"$(=MAX([Week Start]))"},[State]={'Closed'},WorkItemType={'Bug'}>}
ID)
-
COUNT(DISTINCT
{<[Week Start]={"$(=MIN([Week Start]))"},[State]={'Closed'},WorkItemType={'Bug'}>}
ID)
)
/
COUNT (DISTINCT[Week Start])
)

 

 And what i want to achieve is to ignore selection when user select field [Week Start], [Week Start]= not working, 

do you have any idea? probably because i use [Week Start] in set analysis ?

1 Solution

Accepted Solutions
Micki
Creator
Creator
Author

Resolve the issue, 

 

[Week Start=]

 

was not working because i had calculated dimension date(floor(WeekStart), when i replace WeekStart instead of calc. dimension, that's works like a charm

View solution in original post

2 Replies
edwin
Master II
Master II

can you try it with single quotes instead of double in the set analysis for WeekStart and if weekstart is a date field use date function in min and max  $(=date(max(...))).  i would split these into 3 expressions and see where it is failing to test.  

Micki
Creator
Creator
Author

Resolve the issue, 

 

[Week Start=]

 

was not working because i had calculated dimension date(floor(WeekStart), when i replace WeekStart instead of calc. dimension, that's works like a charm