Use Variable Field Entry in Tab Formula

[Rainer1]

Hello everybody,
I am using QlikView for a few years but now struggeling with a small modification.

I have created a table for price analysis of sales items. So far it worked quite well as I had used fixed formulas for each row. Now I want to make the analysis more flexible by having the possibility to enter the relevant year with a variable field (see field indicated with an arrow). The year I have entered should be recoginzed in the formula. But it is not working.

What is wrong? How does the formula exaclty need to be written?

Thanks in advancePicture

[AshutoshBhumkar · Accepted solution]

Hello,

If you want the selected value to be appeared in the set you can use below set in your expression

e.g Sum({<Year={"$(=GetFieldSelections(Year))"}>} Sales)

If you are trying to get the entered Year from variable input you can use the variable instead.

e.g Sum({<Year= {"$(vVariable)"}>}Sales)

Hope this helps.

Thanks,

Ashutosh

[Rainer1]

Thanks Ashutosh,
this was exactly what I am looking for. Now my tab calculation works perfectly.
BR
Rainer

[AshutoshBhumkar]

Great 🙂

[Rainer1]

How can I add a second variable which has to be matched into the formula Sum({<Year= {"$(vVariable)"}>}Sales)?
I tried Sum({<Year= {"$(vVariable)"}>};{<Month= {"$(vVariable2)"}>}Sales) and other variations but without success.

[AshutoshBhumkar]

try 

Sum({<Year= {"$(vVariable)"} , Month= {"$(vVariable2)"}>}Sales)

There is an issue with set expression syntax.