topic How to write if condition in setexpression in QlikView

How to write if condition in setexpression

Anonymous — Mon, 20 Apr 2015 14:50:51 GMT

Hi Friends,

I want to display count of some ticketid based on difference of two date fields

=Count(DISTINCT {<Process={'Change'},[Call_Day of Month]=,Call_Month=,Call_Year=>}

if( Round ( Date(Date#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY') -Date(Max(Call_Date),'MM/DD/YYYY'))>= 0 and

Round( Date(Date#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY') -Date(Max(Call_Date),'MM/DD/YYYY')) <=60,TicketID))

Please suggest me..

Thanks in Advance

Siva

sunny_talwar — Mon, 20 Apr 2015 14:55:52 GMT

May be this:

=Count(DISTINCT {<Process={'Change'},[Call_Day of Month]=,Call_Month=,Call_Year=>}

If([Scheduled Start Date Time] - Max(Call_Date) >= 0 and [Scheduled Start Date Time] - Max(Call_Date) <= 60, TicketID))

Best,

Sunny

Anonymous — Mon, 20 Apr 2015 14:58:12 GMT

hi, try

if( Round ( Date(Date#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY') -Date(Max(Call_Date),'MM/DD/YYYY'))>= 0 and

Round( Date(Date#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY')) -Date(Max(Call_Date),'MM/DD/YYYY')) <=60,

Count(DISTINCT {<Process={'Change'},[Call_Day of Month]=,Call_Month=,Call_Year=>}TicketID))