topic Expression that ignores some selections and contains where conditions in QlikView

Expression that ignores some selections and contains where conditions

matthewp — Fri, 06 May 2016 13:08:08 GMT

I have an expression SUM(value)

i want to also have an expression that does 2 things

ignores all list box selections except 1 box

and

contains where conditions

(SUM(value) Where category = 'abc'/SUM(TOTAL value Where category = 'abc' OR 'xyz')

and only affected by selections from the yearperiod selection box nothing else

jyothish8807 — Fri, 06 May 2016 13:15:38 GMT

Hi matt,

Try like this:

sum({<category={'abc'},listbox1=,listbox2=,listbox3=>}value) /

sum({<category={'abc','xyz'},listbox1=,listbox2=,listbox3=>}total value)

listbox1, listbox2 are the listbox whose selection should not be effected.

Mention all the list box apart from yearperiod in set annalysis.

Hope it helps.

Regards

matthewp — Fri, 06 May 2016 13:19:50 GMT

by listbox1 do you mean the object id e.g. LB251 or the title?

MK_QSL — Fri, 06 May 2016 13:21:47 GMT

SUM({1<yearperiod = $:: yearperiod, Category = {'abc'} >}Value)/SUM(TOTAL {1<yearperiod = $:: yearperiod, Category = {'abc','xyz'} >}Value)

matthewp — Fri, 06 May 2016 13:24:53 GMT

i want to also have where conditions inside the expression and divide by another expression (see question)

your on the right track though

MK_QSL — Fri, 06 May 2016 13:26:09 GMT

I have edited my reply..