topic Re: Conditional Expression in QlikView

Conditional Expression

gfisch13 — Wed, 25 Nov 2020 16:16:04 GMT

Hi - I'm having an issue understanding how/when to use functions. I'm trying to count distinct case numbers where:

Case Type = Claim AND Amount_At_Risk >= 250,000

Can anyone suggest an expression to use?? Also, is there any documentation to research for expressions so I can learn from a good starting point???

Thanks!

Re: Conditional Expression

miguelbraga — Tue, 13 Sep 2016 13:43:52 GMT

Here is an expression you can use:

If by 250,000 you meant 250:

Count({$<Type = 'Claim', Amount_At_Risk = {'>=250)'}>} distinct [you desired dimention])

If not, you meant 250000:

Count({$<Type = 'Claim', Amount_At_Risk = {'>=250000)'}>} distinct [you desired dimention])

PS: Replace [you desired dimention] by your field for example:

Count({$<Type = 'Claim', Amount_At_Risk = {'>=250000)'}>} distinct ID_Number)

Hope this serves you

Regards,

Re: Conditional Expression

trdandamudi — Tue, 13 Sep 2016 13:46:38 GMT

May be as below:

Count( {<Case_Type = {'Claim'}, Amount_At_Risk = {'>=250000'}>} Distinct CaseNumber)

Note: I updated as Sunny mentioned below:

Replace CaseNumber field with your field name,

Re: Conditional Expression

sunny_talwar — Tue, 13 Sep 2016 14:01:17 GMT

I think you mean this

Count( {<Case_Type = {'Claim'}, Amount_At_Risk = {'>=250000'}>} Distinct CaseNumber)

Re: Conditional Expression

gfisch13 — Tue, 13 Sep 2016 14:14:31 GMT

This is what the expression builder is showing. It accepted your expression as shown above but as you can see there is nothing showing on the chart. Which part is the set modifier?

Re: Conditional Expression

trdandamudi — Tue, 13 Sep 2016 14:15:45 GMT

Yes.... I will update the post.... Thanks....

Re: Conditional Expression

trdandamudi — Tue, 13 Sep 2016 14:20:31 GMT

Can you please share a small sample......

Re: Conditional Expression

sunny_talwar — Tue, 13 Sep 2016 14:20:55 GMT

I think you missed an equal sign after AMOUNT_AT_RISK_USD field

Re: Conditional Expression

sunny_talwar — Tue, 13 Sep 2016 14:21:52 GMT

Count( {<Case_Type = {'Claim'}, Amount_At_Risk = {'>=250000'}>} Distinct CaseNumber)

Re: Conditional Expression

gfisch13 — Tue, 13 Sep 2016 14:25:30 GMT

Perfect, such a small detail makes a difference. Where would you suggest I go to learn about sets, other expressions. This is confusing!!!

Re: Conditional Expression

miguelbraga — Tue, 13 Sep 2016 14:28:14 GMT

Check this post on the comunity, it explains better the Set Analysis philosophy:

https://community.qlik.com/docs/DOC-4951

Regards,