topic Re: User Input : Store : Manipulate : Retrieve in QlikView

User Input : Store : Manipulate : Retrieve

nico_ilog — Mon, 20 Oct 2014 09:11:30 GMT

Good Day community,

I have a requirement from a client where they want a solution that encapsulates the following scenario:

1. Set the "Yearly" Targets for a REPs (Re-Sellers of their product)

2. Store this Target (was thinking of storing into a QVD)

3. From their DB i will get the Current (which wil vs Target)

4. This target will obviously become smaller in size as the "Current" grows in size.

My question is:

What solution types can i look at to try and build this sort of solution?

What iv'e been trying:

1. I've tried creating a Variable, for each Rep (about 6), which should hold the "Target"

2. Created a INLINE loaded table, immediately assigning the Variable, to the Rep's Code.

The issue here is that cannot give the created Variable a value, and have it remain at the "given" value... as it loses the value, back to "0" after the reload?

let varTarget_218 = 0 ;

Targets:

LOAD * INLINE [

TRep_Code, Target_Year, Target_p/Month, Target_Current, Target_Remaining

218,(=$varTarget),10,80,20

Anyone got, any sort of input or idea or help?

Thanks in advance.

Re: User Input : Store : Manipulate : Retrieve

Gysbert_Wassenaar — Mon, 20 Oct 2014 09:24:52 GMT

Perhaps this blog post helps: Loading Data into Input Boxes

Re: User Input : Store : Manipulate : Retrieve

tresB — Mon, 20 Oct 2014 09:26:04 GMT

let varTarget_218 = 999 ;

Targets:

LOAD * INLINE [

TRep_Code, Target_Year, Target_p/Month, Target_Current, Target_Remaining

218,$(varTarget_218),10,80,20
]

This doesn't reset your variable to zero ! Am I missing something?

Re: User Input : Store : Manipulate : Retrieve

nico_ilog — Mon, 20 Oct 2014 09:41:49 GMT

Let me have a look! Ill let you know!

Thanks!

Re: User Input : Store : Manipulate : Retrieve

nico_ilog — Mon, 20 Oct 2014 09:45:56 GMT

Nope... didnt work.. =(

Re: User Input : Store : Manipulate : Retrieve

tresB — Mon, 20 Oct 2014 10:37:23 GMT

Could you explain a bit more? How did you try? What is you expected output?