Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
DutchHans
Contributor II
Contributor II

Using a date variable within a set analysis

I have a constant date in a set analysis formula as stated below:

Sum({1<AdmCode-={20,22},LoontijdvakNr={2},GeaccordeerdVT={"<=5-03-2020"}>}Bedrag)

What I want is to replace the date with a variable. Note that there is also a comparison "<=" (smaller or equal to) in the equation.

I know that I have to use $(VariableName) but I do not succeed in a workable solution.

For every new problem someone probably found a solution already ...
Labels (2)
1 Solution

Accepted Solutions
PradeepK
Creator II
Creator II

Sum({1<AdmCode-={20,22},LoontijdvakNr={2},GeaccordeerdVT={"<=$(=vName)"}>}Bedrag)

where vName is your variable.

 

Refer to my reply from this post - Link 

View solution in original post

1 Reply
PradeepK
Creator II
Creator II

Sum({1<AdmCode-={20,22},LoontijdvakNr={2},GeaccordeerdVT={"<=$(=vName)"}>}Bedrag)

where vName is your variable.

 

Refer to my reply from this post - Link