topic Re: Using two variables for expression in QlikView

Using two variables for expression

Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

i want to create a expression between two excisted variables.

vGrossSales = sum(TransactionQuantity*SalesPrice)
Netto_Return_Value = sum(GrossValue-DiscountValue)

i would like to create a new variable called vNettoSales from the two variables upstairs. the formule is : vNettoSales = vGrossSales - Netto_Return_Value.

how can i create this vNettoSales variable? any examples?

Thanks in advances!

Greets,

Rega

Re: Using two variables for expression

sunny_talwar — Tue, 10 May 2016 13:02:13 GMT

Are you creating the variables in the script or through variable overview on the front end?

Re: Using two variables for expression

Tue, 10 May 2016 13:03:16 GMT

Front End

Re: Using two variables for expression

trdandamudi — Tue, 10 May 2016 13:07:29 GMT

In the variable overview you create the below variable:

vNettoSales = ( vGrossSales - Netto_Return_Value)

Then in your charts you can use it as =$(vNettoSales )

Re: Using two variables for expression

avinashelite — Tue, 10 May 2016 13:24:04 GMT

try like this

vNettoSales = vGrossSales - Netto_Return_Value

vNettoSales= sum(TransactionQuantity*SalesPrice) - sum(GrossValue-DiscountValue)

Re: Using two variables for expression

Tue, 10 May 2016 13:29:12 GMT

Hello Thirumala,

Thank you. But i have a new challenge and you can see underneath in the picture:

I created a straight table with the labelname 2016 Netto Sales with the folowing expression:

sum({$<Year={'2016'}>}$(vNettoSales ))

unfortunatly i can't see any result in the the straight table. probably a wrong expression?

Thanks!

Rega

Re: Using two variables for expression

avinashelite — Tue, 10 May 2016 13:33:58 GMT

Yes your expression is wrong

sum({$<Year={'2016'}>}$(vNettoSales ))

you should have a field to use the set analysis expression

try like this

sum({$<Year={'2016'}>}TransactionQuantity*SalesPrice) - sum({$<Year={'2016'}>}GrossValue-DiscountValue)

if not yielding the right results ..please explain your requirement

Re: Using two variables for expression

sunny_talwar — Tue, 10 May 2016 13:36:08 GMT

Or use variables with parameter:

Variables with Parameters

Re: Using two variables for expression

trdandamudi — Tue, 10 May 2016 13:36:52 GMT

Your expression is wrong. Can you share a small sample please...