topic Re: Set variable based on another field in QlikView

Set variable based on another field

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 2 fields, Period and QTR, the table looks like the following..

What i want to do is to set a variable vCurrentQTR to use the QTR linked to the another variable vCurrentPeriod.

So vCurrentPeriod is 12, so i would want the vCurrentQTR variable to be set at 4.

Can anyone help please?

sunny_talwar — Fri, 25 May 2018 14:07:12 GMT

May be like this

Only({<Period = {'$(vCurrentQTR)'}>}QTR)

hopkinsc — Fri, 25 May 2018 14:20:40 GMT

Hi Sunny,

That doesn't seem to be correct,

What i need is to use an action to set the vCurrentQTR to the current QTR based on the vCurrentPeriod variable.

So in the attached the vCurrentPeriod = 12.

in the table, P12 = QTR 4.

So i want the vCurrentQTR variable to show 4

does that make sense? !

sunny_talwar — Fri, 25 May 2018 14:36:40 GMT

Use this

=Only({<Period = {'$(vCurrentPeriod)'}>}Qtr)

hopkinsc — Fri, 25 May 2018 14:41:43 GMT

Damn, i tried that but i copied and pasted your first reply and changed the variable but the field name was uppercase and my real data is lowercase!

Thanks!

i don't suppose you have any ideas about my post yesterday?

sunny_talwar — Fri, 25 May 2018 14:44:00 GMT

Not yet... I have not got a chance to look at it ... too complicated to solve quickly

hopkinsc — Fri, 25 May 2018 14:51:36 GMT

OK , sorry its so complicated!

sunny_talwar — Fri, 25 May 2018 14:52:44 GMT

You don't have to sorry... it is me who is sort of lazy...

hopkinsc — Fri, 25 May 2018 14:55:51 GMT

haha! well i would appreciate the help when you have the time.

Many thanks!