Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sofiavaz
Contributor

Convert expressions from QlikSense to QlikView

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!

5 Replies
sureshqv
Esteemed Contributor III

Re: Convert expressions from QlikSense to QlikView

what error you are facing?

could post the error message?

Re: Convert expressions from QlikSense to QlikView

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

sofiavaz
Contributor

Re: Convert expressions from QlikSense to QlikView

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!

Digvijay_Singh
Honored Contributor III

Re: Convert expressions from QlikSense to QlikView

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

sofiavaz
Contributor

Re: Convert expressions from QlikSense to QlikView

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

Community Browser