topic Re: Calculating different values depend choosing different values in listbox in QlikView

Calculating different values depend choosing different values in listbox

Anonymous — Fri, 26 Jun 2015 05:51:22 GMT

Good day!

In my test model i try calculate different values in one expression, which have the same name in listbox.

Is it possible to implement it?

For example, if i choose "Volume", my expression must calculate sum of volume, in other case - sum of weight.

There's model in attachment. !

swuehl — Fri, 26 Jun 2015 05:54:52 GMT

You can use conditional expressions.

Siva_Sankar — Fri, 26 Jun 2015 06:08:05 GMT

You can use variable and use it in your expression, an other method. refer the attached.

Anonymous — Fri, 26 Jun 2015 06:08:21 GMT

create a variable vMeasure=GetFieldSelections(Title)

then use expression sum($(vMeasure))

So that if you will have multiple values in list box and and select one it will work fine .

Thanks

BKC

Anonymous — Fri, 26 Jun 2015 06:18:02 GMT

Many thanks))

Anonymous — Fri, 26 Jun 2015 06:18:15 GMT

Thank you for your help!!

Anonymous — Fri, 26 Jun 2015 06:18:25 GMT

Thanks.

Anonymous — Fri, 26 Jun 2015 06:47:01 GMT

But if in table Main i Use dimension name with space, this way is not working.

See files in attachment