Please help with writing a set expression!

rthanga2 — Sat, 16 Nov 2024 03:21:39 GMT

Hello All,

I have three tables i am importing as shown below, Table 1, Table 2 and Table 3. What i want to do is basically make KPI boxes with "Low", "Medium", "High" as shown in the guideline to show revenue in each of the category as shown in the Result below.

To explain Table 1 has Main Part, Components and Supplier for each component. Table 2 has revenue in Main part level i.e Revenue will be for A not for A1,A2 or A3 components. and Table 3 will have scores for suppliers in the range of 1 to 100.

So what the expression should do is for A since the suppliers are S1,S2 and S3 but since S3 has the highest score i.e 65 the revenue for A i.e $2000 will be associated with "High" and similarly B,C,D will be associated with "Medium" since there is only one supplier and and these suppliers fall under medium so the "Medium" KPI should sum to $5500.

Can you help me in writing a chart expression for this? Basically three KPI boxes for Low, Medium and High showing total revenue in that category.

Table:1

Main Part	Components	Supplier
A	A1	S1
A	A2	S2
A	A3	S3
B	B1	S2
C	C1	S4
D	D1	S4

Table 2

Main Part	Revenue
A	$2,000
B	$1,000
C	$3,000
D	$1,500

Table 3

Supplier	Score
S1	25
S2	45
S3	65
S4	50

Guideline:

Low	<40
Medium	40 to 60
High	60

Result:

Low: $0 Medium : $5500 ($1000 + $1500 +$2000) High:$2000

Thanks,

Rakesh

Re: Please help with writing a set expression!

Gysbert_Wassenaar — Sat, 08 Jun 2019 06:57:45 GMT

Please don't clutter this site with duplicate posts: https://community.qlik.com/t5/New-to-Qlik-Sense/Please-help-with-set-expression-for-the-charting-in-Qlik/m-p/1589722#M137634

topic Please help with writing a set expression! in QlikView

Please help with writing a set expression!

Re: Please help with writing a set expression!