Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

evaluate an expression for excluded values in a particular field.

Hi All,

I was trying to evaluate an expression for excluded values in a particular field. using 1-$ evaluates the expression for all excluded values.

How do I accomplish this only for 1 or 2 fields?

Thanks,

Neeraj

1 Solution

Accepted Solutions
Not applicable

Re: evaluate an expression for excluded values in a particular field.

Try this:

Plz find the attached file.

4 Replies
Not applicable

Re: evaluate an expression for excluded values in a particular field.

Try this:

Plz find the attached file.

Not applicable

Re: evaluate an expression for excluded values in a particular field.

Hi

Please Use this formula.

sum(if(FieldName<>'FieldValue',Amount))

Regards

Ashish

Not applicable

evaluate an expression for excluded values in a particular field.

Neeraj is looking for solution to get a two dimensional selection.

First one to get a exclueded value, and the second one for getting more granulity on the second label.

1-$ value is going to give the exluded value for first time selected value.

But it will not work, if there is another granulity label associated with the selection.

So it is a set analysis inside set analysis.

Please give your suggestion according for that

Regards,

Lalmohan

Not applicable

evaluate an expression for excluded values in a particular field.

Thank you Erica.