topic Re: Variabilize set modifier in QlikView

Variabilize set modifier

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have defined as Time Dimensions as below:

Date defined as vTimeDim = 1,

Week defined as vTimeDim = 2,

Month defined as vTimeDim = 3,

Year defined as vTimeDim = 4. vTimeDim is the action given to the text Objects so that user can toggle between the different time dimensions.

And I have expression as

pick(vTimeDim,

sum({<Link_Date={'$(vToDate)'}>}Applications,

sum({<Link_Date={">=$(=DATE(weekstart(vToDate)))<=$(vToDate)"}>}Applications,

sum({<Link_Date={">=$(=DATE(monthstart(vToDate)))<=$(vToDate)"}>}Applications,

sum({<Link_Date={">=$(=DATE(yearstart(vToDate)))<=$(vToDate)"}>}Applications)

Is there a way to variablize the date modifier, so that I can write just one expression.

Something like =sum({<$(vTimeSetExp)>}Applications.

I'm not sure how to put the date modifiers into vTimeSetExp

Thanks for all the help in advance.

Re: Variabilize set modifier

sunny_talwar — Mon, 29 Aug 2016 21:32:51 GMT

How about this:

Sum({<Link_Date = {"$(=Pick(vTimeDim, '$(vToDate)', >=$(=Date(WeekStart(vToDate)))<=$(vToDate), >=$(=Date(MonthStart(vToDate)))<=$(vToDate), >=$(=Date(YearStart(vToDate)))<=$(vToDate))"}>}Applications)

Re: Variabilize set modifier

Mon, 29 Aug 2016 22:46:18 GMT

Sunny, Appreciate your quick and prompt response.

Is there a way to completely get rid of Link_Date = {"$(=Pick(vTimeDim, '$(vToDate)', >=$(=Date(WeekStart(vToDate)))<=$(vToDate),>=$(=Date(MonthStart(vToDate)))<=$(vToDate), >=$(=Date(YearStart(vToDate)))<=$(vToDate))"} this par.

I mean can we replace it with a variable. Because I have about 50 metrics and I'll have to write this part for all of them right.

Re: Variabilize set modifier

sunny_talwar — Mon, 29 Aug 2016 23:06:20 GMT

See if you like the approach in the attached qvw file. I can provide another one based on a variable, but this one uses a technique from an inline load in the script.

Re: Variabilize set modifier

Anonymous — Tue, 30 Aug 2016 07:41:34 GMT

Hi aditya,

You can use variable functions to create a variable Set Analysis. See this post:

https://community.qlikview.com/thread/18030

For example:

Your variable: ='{<Link_Date={">=$(=DATE('&$1&'(vToDate)))<=$(vToDate)"}>}'

Your expression: sum($(YourVarName('weekstart'))Applications)

Regards!!