topic Re: Date selection in Multi box generating incorrect o/p in QlikView

Date selection in Multi box generating incorrect o/p

Mon, 25 May 2015 12:10:23 GMT

Hi Team,

I have an application where user has option to select Date, and on selection I have to show MTD,QTD, YTD till selected date,but if there is no sale for that particular date then nulls are coming which results into incorrect values. This is the expression I am using

sum({<KeyID={1,2,4,5,12},

SaleDate={">=$(=monthstart(GetFieldSelections(SaleDate)))<=$(=GetFieldSelections(SaleDate))"}

>}Quantity)

SaleDate is in Multibox which user selects.

Please help.

Regards,

Navdeep

Re: Date selection in Multi box generating incorrect o/p

tresB — Mon, 25 May 2015 12:31:41 GMT

Try like:

sum({<KeyID={1,2,4,5,12},

SaleDate={">=$(=monthstart(Max(SaleDate)))<=$(=Max(SaleDate))"}

>}Quantity)

Re: Date selection in Multi box generating incorrect o/p

Mon, 25 May 2015 12:44:56 GMT

Hi,

Tried it, but no success, now nothing is showing up for the dimension values which don't have sales for selected date.

Can I use some variable using calendar object ?

Regards,

Navdeep