topic Re: Expression based on dimension? in QlikView

Expression based on dimension?

Fri, 10 May 2013 08:36:56 GMT

Hey,

I have a time dimension and an expression based on a growth variable (e.g. 10% growth per month). If the user zooms in to weekly, daily or lower levels the formula won't work because the corresponding growth rate refers to month number.

Is it possible to use an if statement to define the variable dynamically based on the dimension? E.g. different expression for, month, week, and so on?

Kr.

Daniel

Re: Expression based on dimension?

swuehl — Fri, 10 May 2013 08:49:37 GMT

I assume you are using a group with your dimension, right?

Then try using system function GetCurrentField() in your if() statement's condition:

GetCurrentField(groupname)

returns the name of the field currently active in the group named groupname.

Example:

getcurrentfield( MyGroup )

Re: Expression based on dimension?

Fri, 10 May 2013 09:25:03 GMT

No just regular time dimensions: year, month, week and so on. Qlikview automatically allows users to drill down, you don't need to group time dimensions.

Re: Expression based on dimension?

Gysbert_Wassenaar — Fri, 10 May 2013 09:47:34 GMT

Something like this maybe:

if( getpossiblecount(day) = 1, dayexpression,

if( getpossiblecount(week) = 1, weekexpression,

if( getpossiblecount(month) = 1, montexpression, yearexpression )))

Re: Expression based on dimension?

swuehl — Fri, 10 May 2013 15:22:54 GMT

If you are using multiple dimensions like year, month, date without a dimension group, I believe you are not drilling down, just selecting some dimension values, aren't you? I mean, the granularity is not changing, because whatever you select, your expression is always evaluated in the smallest granularity of dimensions year, month, date (i.e. date), right?

I am probably missing something essential here, could you post a small sample app?

Re: Expression based on dimension?

Fri, 10 May 2013 16:04:01 GMT

Swuehl, let's just say it's friday.. Indeed I created a group a long time ago.. which allows drill down functionality. Apart from the drilldown group I also have several listboxes where users can indeed select.

The if statement solution should work. Thanks a lot!