Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Format Issue

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)

MonthField.PNG

1 Solution

Accepted Solutions
sunny_talwar

Why don't you use this

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


and this

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

View solution in original post

4 Replies
sunny_talwar

Why don't you use this

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


and this

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

YoussefBelloum
Champion
Champion

Hi,

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

juraj_misina
Partner Ambassador Affiliate
Partner Ambassador Affiliate

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
Creator III
Creator III
Author

Hi Sunny,

Thank You . you are always awesome.

sorry for my late reply.

Best Regards,

HK