topic Needed a Correction in a syntax in QlikView

Needed a Correction in a syntax

kunkumnaveen — Wed, 07 Jul 2021 05:01:56 GMT

Hello All ,GM

I trying to sort Bucket Column based upon Bucket Date at backend (Scripting),the syntax I have written is

Dual(Bucket,num(date(Timestamp#(Bucket_Date, 'MM/DD/YYYY hh:mm:ss'), 'YYYY/MM/DD' ))) as [Bucket],

output :

If we observe the above table the Values in the Bucket Column(3rd) suppose to be as same as the test_Bucket column but what I am getting is wrong

Please suggest what change do I need to do in the dual Syntax or can we sort the bucket with any other syntaxs

Thanks

Re: Needed a Correction in a syntax

avinashelite — Wed, 07 Jul 2021 05:39:35 GMT

I don't see any issue with the syntax , please check on the expression results , I feel it is giving he null/blank output

Re: Needed a Correction in a syntax

marcus_sommer — Wed, 07 Jul 2021 12:11:59 GMT

BucketDate needs to be to correspond with the multiple values from Bucket - but this doesn't happens here. Regarding to your screenshot you have two different dates and therefore you get two different string-values from Bucket.

This means you couldn't use BucketDate as numeric value within the dual(). Maybe you could use another field and/or creating with recno(), rowno() and/or autonumber() in any combination an unqiue field-value. Another approach might be to load the relevant tables and/or fields-combinations with your wanted sort-order.

- Marcus