topic Re: If condition issue in QlikView

If condition issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to qlikview, I want to get the max date of the below group. please help

if (AR_GRP2={'OT','AD','GG','OC','GM'},

DATE(max(TICKET_DATE),'DD-MMM-YYYY')

if i am giving DATE(max(TICKET_DATE),'DD-MMM-YYYY') then its working fine but when I am adding condition AR_grp2, then its not working.

Regards,

Adeel

swuehl — Sat, 12 Mar 2016 10:01:56 GMT

You are using this in an expression, right? And your dimension is not AR_GRP2, is it?

Always use aggregation functions in expressions:

=DATE(max(if (Match(AR_GRP2,'OT','AD','GG','OC','GM'),TICKET_DATE)),'DD-MMM-YYYY')

or using set analysis:

Date( Max({< AR_GRP2={'OT','AD','GG','OC','GM'} >} TICKET_DATE),'DD-MMM-YYYY')

HirisH_V7 — Sat, 12 Mar 2016 13:05:59 GMT

Hi,

You can use expressions like this,

if(AR_GRP2='OT','AD','GG','OC','GM',Max(Date))

By using Set Analysis,

Max({<AR_GRP2={'OT','AD','GG','OC','GM'}>}TICKET_DATE)

HTH,

Hirish

jagan — Sat, 12 Mar 2016 16:04:15 GMT

Hi,

Try this using set analysis

DATE(max({< AR_GRP2={'OT','AD','GG','OC','GM'} >} TICKET_DATE),'DD-MMM-YYYY')

Regards,

jagan.

Sun, 13 Mar 2016 04:36:50 GMT

Below expression is working fine.

Date( Max({< AR_GRP2={'OT','AD','GG','OC','GM'} >} TICKET_DATE),'DD-MMM-YYYY')

Thank you all.