topic Re: Combine Set expression in QlikView

Combine Set expression

vchuprina — Tue, 29 Nov 2016 08:14:38 GMT

Hi All,

I have following expression:

$(vTotalOrder)

sum(OrderLA)

______________________

$(vShipped)

sum(
{$ <[Order Status]*={'*1', '1*'},
[Code]*=-{'To'}>
} OrderDA )

______________________

$(vCalcOrder)

=$( vTotalOrder)-$( vShipped)

______________________

$(vOrderInBack)

sum(
{$ <
[Order Status]={'>=01<=12'},
[Code]=-{‘To’},
[$(=DateF) Date]*={'<$(vCalcDate)'}
>}
(OrderLA-OrderIA))

I need to know how many OrderInBack in vCalcOrder.

How can I combine those set expressions?

MK_QSL — Tue, 29 Nov 2016 08:47:27 GMT

Provide few lines of sample data or sample app to work along with your expected output.

vchuprina — Tue, 29 Nov 2016 09:27:48 GMT

Hi Manish

Order Status

Code

For

Rec