topic Convert expressions from QlikSense to QlikView in QlikView

Convert expressions from QlikSense to QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Convert expressions from QlikSense to QlikView

Chanty4u — Tue, 13 Mar 2018 11:44:46 GMT

what error you are facing?

could post the error message?

Re: Convert expressions from QlikSense to QlikView

Anil_Babu_Samineni — Tue, 13 Mar 2018 11:48:58 GMT

Haha, good question. But set analysis is same for both view and sense.. which version you are using?

Re: Convert expressions from QlikSense to QlikView

Anonymous — Tue, 13 Mar 2018 11:57:12 GMT

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!

Re: Convert expressions from QlikSense to QlikView

Digvijay_Singh — Tue, 13 Mar 2018 14:28:21 GMT

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

Re: Convert expressions from QlikSense to QlikView

Anonymous — Tue, 13 Mar 2018 16:02:07 GMT

Thank you Dibvijay. I've made that change but the output is the same...