topic Ignore field selection in set expression in QlikView

Ignore field selection in set expression

Micki — Fri, 22 Jan 2021 17:41:10 GMT

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 ?

Re: Ignore field selection in set expression

edwin — Fri, 22 Jan 2021 22:59:54 GMT

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.

Re: Ignore field selection in set expression

Micki — Sat, 23 Jan 2021 11:20:09 GMT

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