topic Re: Variable as a Dimension in App Development

Variable as a Dimension

bbergstrom — Wed, 31 Oct 2018 13:09:35 GMT

In Qlik Sense I am trying to create a variable, or even a master dimension, that checks to see if the date on the record is between to variable dates. I have tried the following and it is giving me an Invalid dimension:

IF(FEFTCount=1 AND [Transaction Date]>=$(vDateFrom) AND [Transaction Date]<=$(vDateTo),ExceptVehFuelType)

The [Transaction Date] and two variable fields have the same date format.

Re: Variable as a Dimension

sunny_talwar — Wed, 31 Oct 2018 13:18:50 GMT

How do you define vDateFrom and vDateTo variables? Make sure they have equal in front of the variable definitation

Re: Variable as a Dimension

bbergstrom — Wed, 31 Oct 2018 13:20:49 GMT

Doing that broke other visualizations. Here is the definition:

IF(ISNULL(GetFieldSelections([Transaction Month])) AND ISNULL(GetFieldSelections([Transaction Week])),Date(Addmonths(Today(),-20),'MM/DD/YYYY'),DATE(MIN(TranDateTime)))

Re: Variable as a Dimension

sunny_talwar — Wed, 31 Oct 2018 13:28:07 GMT

May be create a new set of variable for this calculated dimension?

Re: Variable as a Dimension

sunny_talwar — Wed, 31 Oct 2018 13:29:35 GMT

Alternatively, you can create the new variable like this

If(IsNull(GetFieldSelections([Transaction Month])) and IsNull(GetFieldSelections([Transaction Week])), Addmonths(Today(), -20), Min(TOTAL TranDateTime))

Re: Variable as a Dimension

bbergstrom — Wed, 31 Oct 2018 13:36:17 GMT

So this variable sets a starting date for set analysis. Why would I add TOTAL?

Re: Variable as a Dimension

sunny_talwar — Wed, 31 Oct 2018 13:40:42 GMT

A calculated dimension cannot have an aggregation (Like Min, Max, Sum, Avg) without TOTAL (one value across the whole dashboard) or without Aggr() (if you need multiple values based on a single dimension or multiple dimensions. In other words, when you have Min(Date) in your calculated dimension, it take it as null. But if you do Min(TOTAL Date) it gives you the Min date across the whole dashboard based on your selections. =Min(Date) does a similar thing where it evaluate to expression to a single value and then passes the value to the calculated dimension. So, now you don't have Min(Date) going into your calculated dimension, but the actual value (for instance 01/01/2018).

Does that make sense?

Re: Variable as a Dimension

bbergstrom — Wed, 31 Oct 2018 13:43:34 GMT

Sort of but this variable is currently working in the set analysis I have. I am not trying to put this variable into a table.

Re: Variable as a Dimension

sunny_talwar — Wed, 31 Oct 2018 13:49:24 GMT

All I am saying is to create a new variable with new expression. Don't make changes to a variable which is already working elsewhere . Not sure if this is something you cannot do or not want to do

Re: Variable as a Dimension

bbergstrom — Wed, 31 Oct 2018 14:39:07 GMT

It worked after I tweaked some of the other data points, thanks!