Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

selvapraveen
New Contributor II

equating strings in a expression

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: equating strings in a expression

Hi,

What about using set analysis:

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

Hope that helps.

Miguel

2 Replies
MVP
MVP

Re: equating strings in a expression

Hi,

What about using set analysis:

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

Hope that helps.

Miguel

selvapraveen
New Contributor II

Re: equating strings in a expression

Thanks Miguel , that works ...

Community Browser