Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Selection of field with If condition

Hi All

I want to pick one value in negative using set analysis with this condition where

CBSDesc = 'TRANSFER OF FUNDS #239983'

CBSAmount<1


then I want the result. This condition is not working in KPI


IF(CBSDesc = 'TRANSFER OF FUNDS #239983' AND CBSAmount<1, sum({$<CBSDesc = {'TRANSFER OF FUNDS #239983'}, 0)

Could you please help with this.

9 Replies
MVP
MVP

Re: Selection of field with If condition

HI,

Try like this

=Max({<CBSDesc = {'TRANSFER OF FUNDS #239983'}, CBSAmount={'<0'}>} SomeFieldName)


Note: Replace SomeFieldName with your actual field name.


REgards,

jagan.

reddys310
Honored Contributor II

Re: Selection of field with If condition

Hi Renu,

As Jagan suggest a set analysis statement should help you solve the issue. Also this document should help you understand the statement.

A Primer on Set Analysis

Thanks,

Sangram.

Not applicable

Re: Selection of field with If condition

Thanks Jagan for your kind help, this worked...

Not applicable

Re: Selection of field with If condition

Thanks Sangram for sharing this document...

MVP
MVP

Re: Selection of field with If condition

Hi,

If you got the answer please close this thread by giving Correct and Helpful Answers to the posts which helps you in getting the answers.

Regards,

jagan.

MVP
MVP

Re: Selection of field with If condition

Hi Renu,

Please close this thread by giving Correct Answer to the post which helps you.

Regards,

jagan.

reddys310
Honored Contributor II

Re: Selection of field with If condition

Always Welcome!

Not applicable

Re: Selection of field with If condition

hi i need if condition to select fields that is if two coloumns are having some datas so i need to add one coloumn data into other coloumn data.

reddys310
Honored Contributor II

Re: Selection of field with If condition

Hi Pramod,

Try this:

if(columnA = Column B, calumnA & ' ' & ColumnB) as fieldname

Thanks,

Sangram.

Community Browser