topic Re: Condition in QlikView

Condition

Tue, 06 May 2014 19:31:45 GMT

Hello,

How can I write a condition where I have "type" is equal to m6. I used an if statement as my expression and it does not seem to like that.

Re: Condition

Anonymous — Tue, 06 May 2014 19:34:56 GMT

if(type='m6', <expression 1>, <expression 2>)

Re: Condition

Anonymous — Tue, 06 May 2014 19:41:53 GMT

it depends on where you are trying to write it...Michael's solution is the simplest. but you may also want to look into set analysis. or provide context...example of a set analysis expression where you are calculating sum of Sales for all entities with "type" = m6 is something like:

Sum({<type={'m6'}>} Sales)

Re: Condition

Tue, 06 May 2014 20:27:35 GMT

Thank you, it doesn't seem to work with either.

Re: Condition

its_anandrjs — Tue, 06 May 2014 20:34:39 GMT

Hi you can write

With SET Analysis for expression

Sum({<type={'m6'}>} Sales)

With If condition for dimension

If( type = 'm6', <Expr1>, <Expr2> )

But strange why this two are not worked.

Re: Condition

Anonymous — Wed, 07 May 2014 05:11:58 GMT

not knowing your requirement or having a sample file, the above expressions are supposed to be examples...you will have to modify them to your specific requirement. if you are expecting an answer that works off the bat, you may want to attach a sample qvw or elaborate your requirements with some details.