topic Re: Expression depending on a field value in QlikView

Expression depending on a field value

Anonymous — Thu, 20 Nov 2014 11:45:30 GMT

Hi, I have in a scatter chart a expressions as simple as this:

Sum(Data)

I also have a table (load inline) with 3 values: SalesAmount, Qty, CostAmount

I display this 3 values in a lis box.

My intention is that when I choose one of this value in the list box, the expression of the chart changes into somethig like this:

Sum(SalesAmount)

Sum(Qty)

Sum(CostAmount)

Any suggestions?

thanks

Re: Expression depending on a field value

rubenmarin — Thu, 20 Nov 2014 11:55:15 GMT

Hi, you can use conditional expressions, create 3 expressions, each one with a different condition, ie, supposing the inlite table field is called 'Metric':

Metric='SalesAmount'

Another option is create nested if expression:

If (Metric='SalesAmount', Sum(SalesAmount))

An another option is to use the value of the selected "Metric" as field name for the expression:

Sum($(=Metric))

Re: Expression depending on a field value

Anonymous — Thu, 20 Nov 2014 12:06:11 GMT

Thanks Ruben, the Sum($(=Metric)) option works pretty weel to me.

Re: Expression depending on a field value

Thu, 20 Nov 2014 12:07:50 GMT

The Following will work

=sum($(=Only(Field)))

See attached example

Re: Expression depending on a field value

Thu, 20 Nov 2014 12:10:54 GMT

hi,

you can try enable condition

and write

if(metric='SalesAmount',1,0)

and then write your respected

sum(SalesAmount)

with regards

harshita Gaur