topic Re: How to store and retrieve Constant values in variable? in QlikView

How to store and retrieve Constant values in variable?

Wed, 20 Aug 2014 13:48:08 GMT

Hello,

The scenario goes this way, 'ID' is my Primary key field, Suppose Count(ID)=10 (Previous Week Monday).

I reload the data today after changes in source, Count(ID)=15 (This week Monday)..

I want to add a text object as 'Vs Previous Week' which will Show '+5'

I want to Store the previous reload count in a variable, retrieve it and Subtract it from current reload count.

There is no other column to calculate it.

Please help.Thanks in Advance.

Regards,

Pratik

Re: How to store and retrieve Constant values in variable?

marcus_sommer — Wed, 20 Aug 2014 14:28:47 GMT

If you have a date-field which is linked to your Key "ID" you didn't need this approach - you could it calculate directly over the date-field. If not I would store these count by every reload in a qvd with an additional field like today() as ReloadDate.

- Marcus

Re: How to store and retrieve Constant values in variable?

Wed, 20 Aug 2014 14:33:07 GMT

Create 2 variables vZ and vY

Try with this code in the script

vZ = $(vY)

vY = $(vY) + 10;//Just a test value:)

Look out of the values vZ and vY in the text Box.

-Ram