topic Re: sql condition in expression(urgent plsssss...) in QlikView

sql condition in expression(urgent plsssss...)

Wed, 06 May 2015 12:36:40 GMT

Hi experts,

I have used the following expression for counting the no. of invoices (MTD) in a pivot table

Expression = count({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} InvoiceNo)

I have to include the following sql condition in the above expression.

sql condition = COUNT(DISTINCT CASE WHEN ORDTYPE='SL' THEN ISNULL(InvoiceNo,'') END)

How can i include this.

please help

Re: sql condition in expression(urgent plsssss...)

Gysbert_Wassenaar — Wed, 06 May 2015 13:04:47 GMT

Try:

count({<ORDTYPE={'SL',} CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} if(IsNull(InvoiceNo),'',InvoiceNo))

Re: sql condition in expression(urgent plsssss...)

Wed, 06 May 2015 14:07:23 GMT

Thanks a lot