topic Is it possible --two selections value as one line in chart !! in QlikView

Is it possible --two selections value as one line in chart !!

ajaykumar1 — Wed, 29 Jan 2014 17:46:18 GMT

Hi Everyone,

I have to do in design level.

I have a list box(TYPE) which contains sales,warehouse,goods,services,marketing.

If am selecting the sales in graph it is showing that value as 50 and for marketing it is 35.

Now what we want is if am selecting the sales it has to show 75 in a graph. The selection of marketing is not necessary now.

Is it possible?

Thanks,

Ajay

MK_QSL — Wed, 29 Jan 2014 17:51:00 GMT

In your expression....

change your definition as

SUM({<TYPE -= {'Marketing'} >}Value)+ SUM({<'Marketing'>}Value)

Please make sure case sensitive

MK_QSL — Wed, 29 Jan 2014 17:56:13 GMT

Or you can have like below also...

SUM({<Type += {'Marketing'}>}Value)