topic Format date in QlikView

Format date

Mahamed_Qlik — Thu, 26 Nov 2015 11:56:27 GMT

Dear All,

I have the expression like :

=Sum( {<Date = {">= $(vStartDate)<=$(vEndDate)"} FareAmount>}

Where vStartDate and vEndDate are may date variable in number format.

I want to format those variable with date format like (DD-MM-YYYY)

and that i want to do in set analysis so it should be like

=Sum( {<Date = {">= $(=Date(vStartDate,'DD-MM-YYYY)<=$('=Date(vEndDate, 'DD-MM-YYYY'))"} FareAmount>}

Please advise how to write in correct sysntax.

Re: Format date

petter — Thu, 26 Nov 2015 19:54:47 GMT

You could either write this - which is the same as you had except for an added (missing) single quote character ' and ending characters for the modifier and set >} removing a misplaced single quote before the equal sign:

=Sum( {<Date = {">= $(=Date(vStartDate,'DD-MM-YYYY')<=$(=Date(vEndDate, 'DD-MM-YYYY'))"}>} FareAmount>}

or - if this DD-MM-YYYY format is already default date format then this:

Sum( {<Date = {">= $(=Date(vStartDate)<=$(=Date(vEndDate))"}>} FareAmount>}