topic Using a variable to calculate a period in an expression in QlikView

Using a variable to calculate a period in an expression

paul_ripley — Fri, 27 Oct 2017 11:03:42 GMT

Hello

I would like to use a report in QV the present results based on the current period in our general ledger system.

I am loading the field cur_period from the general ledger system

Period:
LOAD * ;
select p.period as cur_period from acrtransgr p

I then set up a variable vCur_period with the definition =cur_period

And then in the expression have used

=sum({$ <period = {"=$(vCur_period)"} >}Count)

to try to pick up the current period, but it doesn't seem to recognise the variable. What am I doing wrong?

Many thanks

Paul

Anil_Babu_Samineni — Fri, 27 Oct 2017 11:10:09 GMT

How you defile the variable? May be this?

=sum({$ <period = {"=$(=vCur_period)"} >}Count)

sunny_talwar — Fri, 27 Oct 2017 11:12:18 GMT

How about this?

=Sum({$<period = p(cur_period)>} Count)

paul_ripley — Fri, 27 Oct 2017 13:03:35 GMT

Thanks Sunny that worked. Can I just ask you the significance of the 'p' before (cur_period)

sunny_talwar — Fri, 27 Oct 2017 13:18:13 GMT

p() and e() are part of indirect set analysis... look here:

sunny_talwar — Fri, 27 Oct 2017 13:18:55 GMT

Also here: