set analysis. By MonthName. dateSet={'Dec 2015'} ok, but dateSet={"$(=MonthName(MAX(dateSet))) is not

[#1]

Just like what the title said...

NUM(   Sum( {$<QUANTITY_UM={"CTN"},Inventory_Date={"$(=DATE(MAX(Inventory_Date), 'DD/MM/YYYY'))"}, dateSet={'Dec 2015'}>}[Ordered Qty]/CONVERSION_QTY),

         '###,###.00'

   )    , this one works. But when I tried to do something like the one below, It doesn't work.

NUM(   Sum( {$<QUANTITY_UM={"CTN"},Inventory_Date={"$(=DATE(MAX(Inventory_Date), 'DD/MM/YYYY'))"}, dateSet={"$(=MonthName(MAX(dateSet)))"}>}[Ordered Qty]/CONVERSION_QTY),

         '###,###.00'

   )

I have tried showing MonthName(MAX(dateSet)) in a column, and the result's format is similar to 'Dec 2015'. Any idea how to make this work Qlikers?

[sunny_talwar]

dateSet is text or DateField? Seems like it is text. How is it getting created in the script?

[#3]

Hi Sunny,

It's you again!
In the load editor, dateSet is created by this " MonthName(Date("Received Date", 'DD-MM-YYYY')) as dateSet,"

[sunny_talwar · Accepted solution]

I don't see why it doesn't work assuming =MonthName(MAX(dateSet)) = 'Dec 2015' in a text box object. Would you be able to share a sample?

[#5]

mm...may I have your email?

[#6]

can't sent to you privately. Not sure where to find your email.

[Anonymous]

Can you try with this?

dateSet={"$(=MonthName(date(MAX(dateSet),'DD-MM-YYYY')))"}

[#8]

tried this too. no luck. The result would return 0.00.

[Kushal_Chawda]

if you have created the dateSet as

MonthName(Date("Received Date", 'DD-MM-YYYY')) as dateSet then below should work

Considering you have data of Jan 2016

NUM(   Sum( {$<QUANTITY_UM={"CTN"},Inventory_Date={"$(=DATE(MAX(Inventory_Date), 'DD/MM/YYYY'))"}, dateSet={"$(=MonthName(addmonths(MAX(dateSet),-1)))"}>}[Ordered Qty]/CONVERSION_QTY)

         '###,###.00'

   )

[tresesco]

See, if this helps you attach a sample: Preparing examples for Upload - Reduction and Data Scrambling