topic Re: Format Issue in QlikView

Format Issue

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Can some one help me here regarding my month format issue.

Based on the timestamp i am calculating my month fields as per below expression.

year([PSA Project Created Timestamp])& num(month([PSA Project Created Timestamp]),'00')

but for one the snapshot metric i am calculating my month timestamp as per below'

Text(Date(Monthstart(today(),-1),'YYYYMM')) (Month is 201809)

But when i try below expression I am not getting months in order.

Text(Date(Monthstart(today(),-1),'YYYYMM'))

Sort Order Expression:

=MAX( {$<Region=, Subregion=, Subregion1=, Subregion2=, Country=,Quardent=,Month=,FY_Month=,FY_QM=,FY_Quarter=,FYear=,Metric=>} FY_Month)

sunny_talwar — Mon, 08 Oct 2018 12:42:03 GMT

Why don't you use this

Date(MonthStart([PSA Project Created Timestamp]), 'YYYYMM')

and this

Date(MonthStart(Today(), -1), 'YYYYMM')

YoussefBelloum — Mon, 08 Oct 2018 12:49:29 GMT

Hi,

what is the format of your field [PSA Project Created Timestamp] ?

juraj_misina — Mon, 08 Oct 2018 12:56:13 GMT

I agree with stalwar1‌: pick one format (ideally Date) and use it in both cases. Otherwise you'll have "discrepancies" like this.

(btw: the sort order you obtain works "as designed" - string values first, followed by numeric values)

dunnalahk123 — Mon, 08 Oct 2018 18:16:22 GMT

Hi Sunny,

Thank You . you are always awesome.

sorry for my late reply.

Best Regards,