Skip to main content
Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BlazkoG
Contributor III
Contributor III

calculate by partly filtered value

Hi, I want tu sum 'value' field as below. Filter by 'mark' field., and I want to do this in set analysis.

ff.jpg

 

So i Want to sum by 'part_no', for every part_no that has occurence of filtered 'mark' field.

I could do this in script editor, but there are tens of distinct 'mark' values, and I want to calculate this in dynamic way.

I might filter more than one value.

Thx in advance for help!

Labels (1)
10 Replies
Ksrinivasan
Specialist
Specialist

hi,

you can try this:

XXXX:
Mapping
Load
Part_No,
Mark;


Load
"Date",
Mark,
Part_No,
Value
FROM [lib://REPORT EXTRACTION /TEST/SSSS1.xlsx]
(ooxml, embedded labels, table is Sheet25)
Where not Mark='-';

DDDD:
LOAD
"Date",
Mark,
Part_No,
ApplyMap('XXXX',Part_No,'') as dede,
Value

your expected Result:

if you select 'X' here that DIM field name is dede:

Ksrinivasan_0-1614683605504.png

if you select 'Y'

Ksrinivasan_1-1614683658682.png

 

ksrini