Qlik Sense Set analysis with variables and ignore other selections

[Ilya_K]

Hi to all .

Background : 

I need to create a calculation with a variable like  this 

Count ({ <DATE={'$(=$(vPrev_Month))'}>} PRODUCT_ID) ) and it's work OK .

Issue: If the user selects only the current month the calculation result return 0 .

Complication: I can't use  Count ({ 1<DATE={'$(=$(vPrev_Month))'}>} PRODUCT_ID) ) because other selections need to reduce product population without problem.

Thanks for help in advance )

[marcus_sommer]

Maybe with:

Count ({ <DATE={'$(=$(vPrev_Month))'}, MONTH = >} PRODUCT_ID) )

[Ilya_K]

Hi , I tried this   ({ < DATE=, DATE={'$(=$(vPrev_Month))'}>} PRODUCT_ID) )  Doesn't work  

[Ilya_K]

I change the order ({ <DATE={'$(=$(vPrev_Month))'},  DATE=   >} PRODUCT_ID) ) and this doesn't work either. The result ignores the variable and represent selected month .

[marcus_sommer · Accepted solution]

You couldn't specify a field several times within a single set statement. Meant was to ignore a selection within MONTH and applied selections came from DATE. If you have only one field DATE which didn't contained dates else a month-value (even if it's structured/formatted as date) you couldn't apply it in this way.

Beside this you need also to check how the variable is defined and if it may react on a selection. I suggest you elaborate in more details which fields with which values are there and should be used as selections, how the variable is defined and the data are associated.

[Ilya_K]

OK , thank  you I got it .

I just split the DATE  field to year , quarter and year_month .

And applied DATE  in function and    year_month  in filters  

Count ({ <DATE={'$(=$(vPrev_Month))'}, YEAR_MONTH = >} PRODUCT_ID) )  and it's works .