topic equating strings in a expression in QlikView

equating strings in a expression

Anonymous — Wed, 24 Jul 2013 17:55:25 GMT

Am trying to build a bar chart with the below as the expression condition in the chart .

if ((IMP_STATUS = 'End'), count(IMP_ORDER))

but this does not work . Earlier i was able to use function returning a numeric value in the if condition . Is there a way to compare it ti a string?

Miguel_Angel_Baeyens — Wed, 24 Jul 2013 18:05:11 GMT

Hi,

What about using set analysis:

Count({< IMP_STATUS = {'End'} >} IMP_ORDER)

Hope that helps.

Miguel

Anonymous — Wed, 24 Jul 2013 18:11:21 GMT

Thanks Miguel , that works ...