Issue filtering dates in set analysis

[Anonymous]

Hi all,

I'm trying to filter a set expression by year. The issue is that the data base only have a field compound by DD-MM-YY (InventoryFrozenInventoryDate).

Does anyone knows what can I do?

Thank you,

Sofia

[arulsettu]

try creating date field like below

Date(Date#(InventoryFrozenInventoryDate,'DD-MM-YY'),'DD/MM/YYYY') as date

then create year and use it in your set analysis

[Anonymous]

Thank you arul settu. I must do this with set analysis, because I can't change the script.

[arulsettu]

can you share your set analysis

[Anonymous]

Now it's like this

Sum({<InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'}>}InventoryFrozenTon)

I would like to add someting like year(InventoryFrozenInventoryDate)=[<"$(=max(Year(InventoryFrozenInventoryDate)))">}

Thank you

[arulsettu]

can you share sample

[arulsettu]

Try this

Sum({<InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'},InventoryFrozenInventoryDate={Year(max(DATE ( Date# ( InventoryFrozenInventoryDate,'DD-MM-YY' ),'DD/MM/YYYY')))}>}InventoryFrozenTon)

[sunny_talwar]

Does Qlik Sense read InventoryFrozenInventoryDate as Date or does it read as a string?

[Anonymous]

Thank you arul settu, but it didn't work

[Anonymous]

as a Date