topic Re: Set Analysis with Variable in QlikView

Set Analysis with Variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created a variable for date selection as below:

vPeriod = if(GetSelectedCount(Period) > 0 , GetFieldSelections(Period), '16/06/1980')
//if(GetSelectedCount(Period) > 0 , Concat(DISTINCT Chr(39) & Period & Chr(39), ', '), Chr(39) & '31/12/2003' & Chr(39))

And using the below expression

=Only({$<Draw={$(=Draw_EM)}, Period={">=$(=vPeriod)"}>} N1)

But when I select other selection then my Date variable does not work.

Can you please advise me related to this?

Kind regards,

Farrukh

Re: Set Analysis with Variable

Chanty4u — Thu, 08 Mar 2018 17:03:40 GMT

period is greater than equal?

Re: Set Analysis with Variable

Anonymous — Thu, 08 Mar 2018 17:12:23 GMT

Hi Chanty,

I have changed to this but still not luck.

=Only({$<Draw={$(=Draw_EM)}, Period={">=$(vPeriod)"}>} N47)

Farrukh

Re: Set Analysis with Variable

sunny_talwar — Fri, 09 Mar 2018 12:06:04 GMT

Not sure I understand?

Re: Set Analysis with Variable

Anonymous — Fri, 09 Mar 2018 13:07:58 GMT

Hi Sunny,

Is the same issue as I had with Draw variable, Now I am selecting multiple fields (Draw & Period).

Example: Draw = EM+

And Period greater then (If date selected else default date for this I created a variable called vPeriod)

When I select Draw is working fine but when I select Draw and Period then Period is not returning the rows.

Please let me know if I explained properly. else I can share the sample qvw file.

Kind regards,

Farrukh

Re: Set Analysis with Variable

sunny_talwar — Fri, 09 Mar 2018 13:12:08 GMT

Please share the qvw sample and explain (meaning provide the exact numerical output) what you need based on few different set of selections

Re: Set Analysis with Variable

Anonymous — Fri, 09 Mar 2018 16:08:22 GMT

Hi Sunny,

Please see the attached qvw file.

as you helped me with Draw Variable. Can you please advise me related to Period (Date Variable).

currently period variable is not working correctly if I add the selection (Draw).

Farrukh

Re: Set Analysis with Variable

sunny_talwar — Fri, 09 Mar 2018 16:12:36 GMT

31/12/2017 is grayed out when I select EM....

Re: Set Analysis with Variable

Anonymous — Fri, 09 Mar 2018 16:47:59 GMT

Hi Sunny,

This is the problem, I do not know why this highlighted in grey. As you can see the below snapshot the data is available for 2017 and 2018.

I am not sure that is my date variable and expression is correct or not.

Re: Set Analysis with Variable

sunny_talwar — Fri, 09 Mar 2018 16:51:26 GMT

Some of the other days are available for selections... but 31/12/2017 is not

Re: Set Analysis with Variable

Anonymous — Fri, 09 Mar 2018 17:00:59 GMT

Thanks a mil sunny for highlighting the missing date on specific dates..

Is there any possibility that If I select Draw then from Period field can be Hide if there is no data and can only display to select the dates where the data is available.

Kind regards,

Farrukh

Re: Set Analysis with Variable

sunny_talwar — Fri, 09 Mar 2018 17:03:01 GMT

You can hide or you can select State as Auto Ascending

Re: Set Analysis with Variable

Anonymous — Fri, 09 Mar 2018 17:16:10 GMT

Thanks a mil Sunny.

Re: Set Analysis with Variable

Anonymous — Fri, 23 Mar 2018 16:35:06 GMT

Hi Youssef,

AR_ID is not a key value, the key Value is "CREATED" field. which is linked to master calendar.

Farrukh