Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
vchuprina
New Contributor III

Combine Set expression

Hi All,

I have following expression:

$(vTotalOrder)

 

sum(OrderLA)

______________________

$(vShipped)

 

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

______________________

$(vCalcOrder)

 

=$( vTotalOrder)-$( vShipped)

______________________

$(vOrderInBack)

 

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

 

I need to know how many OrderInBack in vCalcOrder.

How can I combine those set expressions?

2 Replies
MVP
MVP

Re: Combine Set expression

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

vchuprina
New Contributor III

Re: Combine Set expression

  Hi Manish

Div

vTotalOrder

vOrderInBack

vShipped

vCalcOrder

76 289 943,85

108 942,16

-91 983,82

76 381 927,67

100

12 576 242,85

6 355,08

-58 056,79

12 634 299,64

200

63 713 701,00

102 587,08

-33 927,03

63 747 628,03

 

Order Status

1

23

42

Code

To

For

Rec