topic Re: Expression help set analysis in QlikView

Expression help set analysis

abhaysingh — Tue, 30 Dec 2014 17:31:34 GMT

Hi all

i have one field FIELD whose values are DS and IS, i want to write expression of sales

sum({<FIELD = {'DS'}>} Sales= this give me sales w.r.t DS

sum({<FIELD = {'IS'}>}Sales = this give me sales w.r.t IS

i want to write it in single expression like if i select DS than it will me DS sales else IS sales in single expression....

pls help.

shree909 — Tue, 30 Dec 2014 17:59:17 GMT

Hi use if condition

If (FIELD = 'DS' ,sum({<FIELD = {'DS'}>} Sales),

If (FIELD = 'IS' ,sum({<FIELD = {'IS'}>} Sales)))

Thanks

abhaysingh — Tue, 30 Dec 2014 18:24:56 GMT

i want to write it in set analysis..

Tue, 30 Dec 2014 18:40:31 GMT

Set a variable like:
vField =if(GetSelectedCount(Field)>0,concat(GetFieldSelections(Field),','),'IS')

then use the Expression:
sum({<Field={"$(vField)"}>} Sales)

Tue, 30 Dec 2014 20:08:34 GMT

Maybe like attached? Similar to above posts

manoj217 — Fri, 17 Aug 2018 12:12:17 GMT

so you are asking you have a list box if you select DS it need to show sales WRT DS right

manoj217 — Fri, 17 Aug 2018 12:16:03 GMT

if (getfieldselections(fields)='DS',sum({<FIELD = {'DS'}>} Sales,sum({<FIELD = {'IS'}>}Sales)