topic convert if statement to set in QlikView

convert if statement to set

Thu, 22 Dec 2011 00:20:50 GMT

Hi, I wonder if its possibel to create a set expression of the below if statement ?

(GetSelectedCount(Week),
sum({$<KEY_ID={'work prel'}>} [Accounted quantity]),
if(sum({$<KEY_ID={'work}>} [Accounted quantity]) = 0
,sum({$<KEY_ID={work prel}>} [Accounted quantity])
,sum({$<KEY_ID={'work'}>} [Accounted quantity]))

)

convert if statement to set

pover — Thu, 22 Dec 2011 01:16:56 GMT

You could create a variable vKEYID that is equal to the following:

=if(GetSelectedCount(Week) or sum({$<KEY_ID={'work'}>} [Accounted quantity]) = 0,'work prel','work')

and then the expression would be:

sum({$<KEY_ID={'$(vKEYID)'}>} [Accounted quantity])

Regards, Karl

convert if statement to set

Thu, 22 Dec 2011 07:25:27 GMT

Hi, Is that soultion more time efficient for the user ?

convert if statement to set

pover — Thu, 22 Dec 2011 18:02:33 GMT

To me it is alot cleaner y easier to write and maintain. I don't know if it is easier to understand and I don't think it will calculate is less time. The only way to find out is by testing it.

Karl