topic Re: Qlik Sense Set analysis with variables and ignore other selections in App Development

Qlik Sense Set analysis with variables and ignore other selections

Ilya_K — Mon, 01 Jul 2024 13:49:36 GMT

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 )

Re: Qlik Sense Set analysis with variables and ignore other selections

marcus_sommer — Mon, 01 Jul 2024 14:02:11 GMT

Maybe with:

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

Re: Qlik Sense Set analysis with variables and ignore other selections

Ilya_K — Mon, 01 Jul 2024 14:06:19 GMT

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

Re: Qlik Sense Set analysis with variables and ignore other selections

Ilya_K — Mon, 01 Jul 2024 14:11:03 GMT

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 .

Re: Qlik Sense Set analysis with variables and ignore other selections

marcus_sommer — Tue, 02 Jul 2024 06:15:43 GMT

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.

Re: Qlik Sense Set analysis with variables and ignore other selections

Ilya_K — Tue, 02 Jul 2024 06:36:05 GMT

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 .