Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've been using this expression in a QLikSense app:
=Sum({<OrdItemHoldCd={'MRTALL','MCTALL'}, OrdItemMillAlloc *={'ATF','FIG','SET'}, OrdItemProdCd={"*"}-{'SHT'},OrdMasterOrdType={'CUST','STOCK-WHSE'},OrdItemOrdStat={'HOLD'}>}if(OrdItemDelDate<>OrdMasterOrdDate, OrdItemOrdKgs))/1000
I need to use it in a QlikView dashboard, but it's not working well... does anyone know if there's something i can't use in QlikView that i'm using in Sense?
Thank you!
what error you are facing?
could post the error message?
Haha, good question. But set analysis is same for both view and sense.. which version you are using?
There isn't any error message displayed but the output is not always the same and, as far as I can suppose, some fields are no being recognized as fields because they are painted in black instead of red.. I let an imaged attached.
Thank you!
Looks like nothing wrong with the expression. What if you change it like this -
=Sum({<OrdItemHoldCd={'MRTALL','MCTALL'}, OrdItemMillAlloc *={'ATF','FIG','SET'}, OrdItemProdCd={"*"}-{'SHT'},OrdMasterOrdType={'CUST','STOCK-WHSE'},OrdItemOrdStat={'HOLD'},OrdItemDelDate={"=OrdItemDelDate<>OrdMasterOrdDate"}>}OrdItemOrdKgs))/1000
Thank you Dibvijay. I've made that change but the output is the same...