Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
cgdonders
Not applicable

Re: Set Analysis Question

Hi Sid,

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

4 Replies
cgdonders
Not applicable

Re: Set Analysis Question

Hi Sid,

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

kaanerisen
Not applicable

Re: Set Analysis Question

Hi,

Is that what you want to get?

exclude.png

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?

kaanerisen
Not applicable

Re: Set Analysis Question

P is Possible and E is Excluded