If condition issue

[#1]

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 · Accepted solution]

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

Always use aggregation functions in expressions:

Use Aggregation Functions!

=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]

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]

Hi,

Try this using set analysis

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

Regards,

jagan.

[#5]

Below  expression is working fine.

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

Thank you all.