topic Re: Date in Expression in QlikView

Date in Expression

priyarane — Wed, 27 Jan 2016 12:15:11 GMT

Hi Community,

I have show date in expression depending on selection - date

my date for date is like below

42306.496701389

42306.774351852

42307.396550926

42309.655138889

42310.837152778

42310.839803241

42310.840185185

for others I am showing like

Only({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}DESCRIPTION)

but I am not able show date. Can some one please help me

Re: Date in Expression

swuehl — Wed, 27 Jan 2016 12:17:30 GMT

Only() will only return a value if there is a single possible distinct value returned.

Maybe use another aggregation function like

Min({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>} Date)

Or explain more detailed what you want to achieve and how your data model looks like.

Re: Date in Expression

sunny_talwar — Wed, 27 Jan 2016 12:24:43 GMT

May be something like this:

Only({<%Date = {"$(='>=' & Num(DayStart($(=vCurrDate))) & '<=' & Num(DayEnd($(=vCurrDate))))"}, %Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, CURRENCY = {'$(=$(vCurr))'}>}DESCRIPTION)

Re: Date in Expression

priyarane — Wed, 27 Jan 2016 12:31:13 GMT

Thanks Sunny and Swuehl for your reply.

This is working for me

only({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}Date(SUBMISSION_DATE))

Numbe tabl - expression default.

Re: Date in Expression

swuehl — Wed, 27 Jan 2016 12:35:00 GMT

Ok, so your request was about formatting?

Please note that your SUBMISSION_DATE values seem to be timestamp in fact, so you can format them as dates using Date() function for display purposes, but the values keep the decimals.