Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Set Analysis Question

Hello All,

I have 4 fields

WeekPlantNet PriceOrder Quantity
1BID123.0016
1BID122.0014
1CAL124.0012
1TAP120.0022
2TER133.0041
3REP127.0015

So set analysis which I am struck in is I want the calculation of PAN locations on the same week

Ex.

If I select week 1 and Plant BID1 so a table should show me same week but Plant CAL1 and TAP1 order quantity Calculations and total value(order qty. * net price) excluding BID1.

Do help!

1 Solution

Accepted Solutions
Partner
Partner

Re: Set Analysis Question

Hi Sid,

Try this: SUM({1<Week=P(Week), Plant-=P(Plant)>} [Order Quantity])

View solution in original post

4 Replies
Partner
Partner

Re: Set Analysis Question

Hi Sid,

Try this: SUM({1<Week=P(Week), Plant-=P(Plant)>} [Order Quantity])

View solution in original post

Highlighted
Contributor III

Re: Set Analysis Question

Hi,

Is that what you want to get?

exclude.png

Highlighted
Not applicable

Re: Set Analysis Question

Thanks to both of you kaan and Coen

Coen given me one correct and Kaan given me for second

thanks a ton both of you.

Also may I know what this P stands for?

Highlighted
Contributor III

Re: Set Analysis Question

P is Possible and E is Excluded