topic Re: Use Variable Field Entry in Tab Formula in QlikView

Use Variable Field Entry in Tab Formula

Rainer1 — Sat, 11 Dec 2021 10:51:15 GMT

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

Re: Use Variable Field Entry in Tab Formula

AshutoshBhumkar — Sat, 11 Dec 2021 13:09:55 GMT

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

Re: Use Variable Field Entry in Tab Formula

Rainer1 — Mon, 13 Dec 2021 14:23:43 GMT

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

Re: Use Variable Field Entry in Tab Formula

AshutoshBhumkar — Mon, 13 Dec 2021 15:53:38 GMT

Great 🙂

Re: Use Variable Field Entry in Tab Formula

Rainer1 — Wed, 15 Dec 2021 13:20:45 GMT

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.

Re: Use Variable Field Entry in Tab Formula

AshutoshBhumkar — Thu, 16 Dec 2021 07:50:16 GMT

try

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

There is an issue with set expression syntax.