topic Re: exclude condition in dimension side in QlikView

exclude condition in dimension side

Sat, 12 Oct 2013 09:47:46 GMT

HI,

How to write @exclude condition in dimension side.@@@@@@@@@

Ex :

If I have selected some data from listbox but in chart I dnt want data depending upon that selection. So how to write dimension expression for that column.

Re: exclude condition in dimension side

israrkhan — Sat, 12 Oct 2013 09:57:03 GMT

Hi,

Do you want to ignore all selections or some selections or dimensions, elaborate a bit more,

but if you want to ignore all selections, use like sum({1} Sales).

if you want to ignore the dimensions then use Total Keyword.

if you want to ignore some selection then use like, sum(${<Brand=>} Sales).

it will ignore the selections only in Brand,

hope it helps, if not, then explain a bit more...

Khan

Re: exclude condition in dimension side

jagan — Sat, 12 Oct 2013 10:02:12 GMT

Hi,

Try like

=Sum({<DimensionName=>} MeasureName)

DimensionName=, excludes the selection in dimension.

Regards,

Jagan.

Re: exclude condition in dimension side

Wed, 16 Oct 2013 04:37:26 GMT

Hi,

Israr, yes I want to ignore only 1 dimension.

So I tried the above expressions given by you and Jagan as

Sum({<DimensionName=>} FieldValue)

This works fine also.

But when I write any if condition in the expression, it does not work.

for eg.:

if (valuetype = 'Current Month', Sum({<DimensionName=>} FieldValue),

if (valuetype = 'Month 1', Sum({<DimensionName=>} FieldValue1) ))

The dimension whose selection I want to ignore, is also available in Pivot table as 1 of the dimension.

Re: exclude condition in dimension side

tresB — Wed, 16 Oct 2013 05:31:59 GMT

Not sure about your requirement. Try like:

Sum({<DimensionName=>} if (valuetype = 'Current Month', FieldValue))

If this does not help, please share your sample app.