topic Re: Variable question in QlikView

Variable question

Mon, 21 Jul 2014 19:59:29 GMT

Hi - I'm looking for a simpler way to do the following. I want to look at data from all transactions with a certain SKU # in the transaction. My current formula is:

SUM({$<TRANSACTION_KEY = P({1<SKU = {'5476024'}>} [TRANSACTION_KEY])>} NET_SALES)

I would like to use an input box to input the SKU number rather than type it in the formula, but this type of formula doesn't seem to allow it. What is the best way to handle this? I may be over-complicating this as well, so any suggestions for simplicity works too. Thank you - Matt

Re: Variable question

avinashelite — Mon, 21 Jul 2014 20:11:20 GMT

1:create a variable first like vInput.

2:Then use the same variable in INPUT box

3:try the expression like this:

SUM({<TRANSACTION_KEY = p([TRANSACTION_KEY],SKU ='$(vInput)' >} >} NET_SALES)

Re: Variable question

maxgro — Mon, 21 Jul 2014 20:26:04 GMT

variable in input box vsku

expression

=SUM({$<TRANSACTION_KEY = P({1<SKU={$(vsku)}>} [TRANSACTION_KEY])>} NET_SALES)

Re: Variable question

Mon, 21 Jul 2014 21:08:05 GMT

Perfect - works like I was hoping. Thank you both!