Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
qingkong
Contributor II
Contributor II

Dimensional conditional grouping

I have two Excel's

Want to achieve the result as shown in the picture below

LOAD
Material,
avg6
FROM [lib://AttachedFiles/AVG6.xlsx]
(ooxml, embedded labels, table is AVG6);

LOAD
Material,
Unrestricted
FROM [lib://AttachedFiles/Mb52_Stock.xlsx]
(ooxml, embedded labels, table is Mb52_Stock);

结果.JPG

1 Reply
vinieme12
Champion III
Champion III

 

Temp:

LOAD
Material,
Unrestricted
FROM [lib://AttachedFiles/Mb52_Stock.xlsx]
(ooxml, embedded labels, table is Mb52_Stock);

Left join(Temp)

LOAD

Material,

avg6

FROM [lib://AttachedFiles/AVG6.xlsx]

(ooxml, embedded labels, table is AVG6);

 

Main:

Load * 

, (Unrestricted/avg6) as Unrestricted_avg6

,If((Unrestricted/avg6)>9,'>9'

      ,If((Unrestricted/avg6)>6,'6-9'

      ,If((Unrestricted/avg6)>3,'3-6','1-3'))) as Interval 

Resident Temp;

Drop table Temp;

 

 

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.