Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum({<InventoryFrozenOrdType -= {'PRS'}, InventoryFrozenInventoryType = {'FINISH'}, InventoryFrozenStat ={'B'}, InventoryFrozenInventoryDate = {"$(='>=' & Date(YearStart(Max(InventoryFrozenInventoryDate)), 'DD-MM-YY') & '<=' & Date(Max(InventoryFrozenInventoryDate), 'DD-MM-YY'))"}>} InventoryFrozenTon)
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
Thank you arul settu. I must do this with set analysis, because I can't change the script.
can you share your set analysis
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
can you share sample
Try this
Sum({<InventoryFrozenOrdType-={'PRS'},InventoryFrozenInventoryType={'FINISH'},InventoryFrozenStat={'B'},InventoryFrozenInventoryDate={Year(max(DATE ( Date# ( InventoryFrozenInventoryDate,'DD-MM-YY' ),'DD/MM/YYYY')))}>}InventoryFrozenTon)
Does Qlik Sense read InventoryFrozenInventoryDate as Date or does it read as a string?
Thank you arul settu, but it didn't work
as a Date