topic Re: Generating a conditional column and count value field (if else) ? in QlikView

Generating a conditional column and count value field (if else) ?

bouderbc — Mon, 27 Mar 2017 11:06:48 GMT

Hi,

if( 'field1=1' or 'field2=2' and field3='3' and toto=1 or toto=2 , butterfly='AN')

I want to generate a field with if else and use count to count the fields to put it in my graph or generate a column in the load to use it in my graphic.

Please Help

Thanx

Re: Generating a conditional column and count value field (if else) ?

sunny_talwar — Mon, 27 Mar 2017 11:25:22 GMT

What is the issue you are running into? May be this

If(field1 = 1 or field2 = 2 and field3 = 3 and toto = 1 or toto = 2 , butterfly = 'AN', 1, 0) as Field

Re: Generating a conditional column and count value field (if else) ?

PrashantSangle — Mon, 27 Mar 2017 11:35:37 GMT

Can you explain with sample data???

Regards,