topic Re: Conditional function that fulfill more than one condition in QlikView

Conditional function that fulfill more than one condition

Anonymous — Wed, 21 Sep 2016 08:47:38 GMT

Hi,

I have a conditional function as a dimension:

Type=

=aggr(

if(sum({<Question={'A','B'}>} Answer) >2, 'Survey1',

if(sum({<Question={'A','B','C','D'}>} Answer) >5, 'Survey2',

if(sum({<Question={'H'}>} Answer) <3, 'Survey3')))

, Name)

Tha data is:

If more than one condition is fulfilled, it just appear the first one.

How it can show all the values?

Thank you

sunny_talwar — Wed, 21 Sep 2016 16:30:17 GMT

What is the expected output here?

Anonymous — Wed, 21 Sep 2016 16:34:13 GMT

In these case Survey2 also should be shown as a dimension because fulfill the condition.

miguelbraga — Wed, 21 Sep 2016 16:37:43 GMT

Hey there,

Have you tried this?

=aggr(

if(sum({<Question={'A','B'}>} Answer) >2, 'Survey1',

if(sum({<Question={'A','B','C','D'}>} Answer) >5, 'Survey2',

if(sum({<Question={'H'}>} Answer) <3, 'Survey3')

)

, Name, Question

)

Best regards,

Data Architect MB

antoniotiman — Wed, 21 Sep 2016 16:53:21 GMT

Hi Sara,

the first condition is always fulfilled.

Change order of If(then,else)

Regards,

Antonio