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

Associated group

I have two sheets sheet1 associated with Sheet2 and returned the field "Qty/AVG6

Want to group field "Qty/AVG6"

The results are shown in the attached picture

I have used ValueList and Aggr without success

I have uploaded the attachment, please help, thank you

2d7847bf-4b12-47a9-b7a1-c3633f12640f.jpg 

b8618ad8-c823-4cb4-919f-c5e712e8025c.jpg

Expressing effect

express.JPG

Labels (3)
3 Replies
vinieme12
Champion III
Champion III

Load

number

,Qty

,Avg6

,if((Qty/Avg6)>9,'>9',if((Qty/Avg6)>6,'6-9',if((Qty/Avg6)>6,'6-9',,if((Qty/Avg6)>3,'3-6','1-3')))) as interval 

From Yourexcel....;

 

From  

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

Dear:

I'm sorry I forgot to explain

Sheet1 and Sheet2 are loaded separately and not together

[cid:image001.png@01D85B05.15E56970]
vinieme12
Champion III
Champion III

Can you also explain the relation between sheet 1 and Sheet 2? how are they associated actually?

Why should Qty value 2905 be divided by Avg6 value 376 and not 511 or 445 ??

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