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

Calculating different values depend choosing different values in listbox

Anonymous — Tue, 30 Jun 2015 06:23:12 GMT

Good day!

In my model i load data from excel file.

Then i calculate sum of fields (Weight, Volume l.) in one expression depend choosing value in list box.

When i choose 'Weight' - it's working.

But when i choose 'Volume l.' - calculating expression is not working.. I think, it's connected with 'space' in name of field Volume l.

Can anyone solve this problem?

MK_QSL — Tue, 30 Jun 2015 06:41:34 GMT

Use below expression

=IF(GetFieldSelections(Title)='Weight', SUM(Weight) , SUM(Объем))

ankit777 — Tue, 30 Jun 2015 06:55:24 GMT

try like this

Anonymous — Tue, 30 Jun 2015 07:02:47 GMT

Thanks.. but i need use expression w/o condition with if construction

ankit777 — Tue, 30 Jun 2015 07:09:08 GMT

Then try like this

Anonymous — Tue, 30 Jun 2015 07:24:46 GMT

Sorry, but i need to calculate both of values in ONE expression, using variable value.

It's main idea of my task.

ankit777 — Tue, 30 Jun 2015 07:31:29 GMT

can u rename this field Объем to Volume l.? Then your original file will give correct solution.

Kushal_Chawda — Tue, 30 Jun 2015 07:34:14 GMT

Please see the attached file.

Your approach is correct but just required little modification in variable

Anonymous — Tue, 30 Jun 2015 07:36:15 GMT

No, it's not working

Anonymous — Tue, 30 Jun 2015 07:37:14 GMT

Thank you!!!

ankit777 — Tue, 30 Jun 2015 07:38:37 GMT

It works. See this.