topic Set Analysis help with p() function in QlikView

Set Analysis help with p() function

ajipaul03 — Sat, 16 Nov 2024 20:11:31 GMT

Hello Experts,

I have this expression

sum( {<TEST_CODE= p(MAX_Days) >} TEST_VOL ) - the intend is to limit to all possible TEST_CODE values for the selection in MAX_Days. I am not sure whats wrong with this expression, but it returns 0

For testing, I've hard-coded a value and it works just fine.

sum( {< TEST_CODE= p( {<MAX_Days={10}> } ) >} TEST_VOL)

Any idea?

Thanks,

Aji

Re: Set Analysis help with p() function

ajipaul03 — Wed, 28 Aug 2019 02:03:37 GMT

BTW the expression is

sum( {<TEST_CODE= p(MAX_Days), MAX_Days >} TEST_VOL )

Re: Set Analysis help with p() function

Arthur_Fong — Wed, 28 Aug 2019 02:26:01 GMT

Does this expression:

sum( {< MAX_Days={"$(=max(MAX_Days))"} >} TEST_VOL )

differ from your expected result?

Re: Set Analysis help with p() function

ajipaul03 — Wed, 28 Aug 2019 02:33:31 GMT

nope.. it doesn't work

Re: Set Analysis help with p() function

Arthur_Fong — Wed, 28 Aug 2019 02:54:24 GMT

Take a look at this post.

https://community.qlik.com/t5/QlikView-App-Development/need-help-understanding-P-in-set-analysis/td-p/1174930

Might be useful.

Re: Set Analysis help with p() function

Arthur_Fong — Wed, 28 Aug 2019 03:20:58 GMT

Try this:

sum( {<TEST_CODE= p(MAX_Days), TEST_CODE>} TEST_VOL )

Re: Set Analysis help with p() function

ajipaul03 — Wed, 28 Aug 2019 03:48:11 GMT

Thanks for the suggestion .
Unfortunately this doesn't get what I am looking for
What I really need is, once the user make selection in MAX_Days, the expression calculates the TOT_VOL all the TEST_CODEs that has the selected MAX_days.

ex. if I select 5, it will limit to REF 2 and 4 in TABLE 2 ( blue color). Where as I want to find the SUM(TOT_VOL) for all B&D TEST_CODES ( Blue and Red)

TABLE 1

REF	MAX_Days
1	20
2	5
3	40
4	5
5	10
6	20

TABLE 2

REF	TEST_CODE	TEST_VOL
1	A	5
1	A	6
1	A	7
1	A	8
2	B	6
2	B	8
3	C	3
3	C	4
3	C	5
4	D	3
4	D	2
5	B	20
5	B	1
6	D	1
6	D	4
6	D	2

Re: Set Analysis help with p() function

Arthur_Fong — Wed, 28 Aug 2019 04:04:27 GMT

Try this:

sum( {<TEST_CODE= p(TEST_CODE),MAX_Days>} TEST_VOL )

Re: Set Analysis help with p() function

Arthur_Fong — Wed, 28 Aug 2019 04:05:27 GMT