topic Re: Help with Variable in QlikView

Help with Variable

hopkinsc — Wed, 12 Oct 2011 12:36:02 GMT

Hi, i need some help setting up an input box.

i currently use the following expression in a straight table..

Round(If ([Deal Description] = '12721 - LUNCH TIME DEAL £3' or [Deal Description] = '200030 - LUNCH TIME DEAL £3' ,Sum(InDealQuantity)/3, Sum(InDealQuantity)/2))

Which basically divides the InDealQuantity for the specified deals descriptions by 3, any other DealDescriptions are divides by 2.

I want to try and have an input box instead where the user chooses the deal, then enters a 'Qty' instead of it being hard coded like above.

My fields are:

InDealQuantity = items sold as part of a deal

I have set up a variable

vTriggerQty

but i don't know what to do on the variable trigger..

Can anyone help?

I have attached a sample

Re: Help with Variable

SunilChauhan — Wed, 12 Oct 2011 13:16:46 GMT

see the attached file

hopee this helps

Re: Help with Variable

hopkinsc — Wed, 12 Oct 2011 13:35:37 GMT

Hi, thanks for your reply, although that's not what i wanted.

I have managed to get it working now though, i changed the expression to:

Sum(InDealQuantity)/vTriggerQty

All other variables i have used in the past have needed triggers to be set up, this was one of the easiest

Thanks