Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

"For each"

Hello,

I need your help because i'm facing an issue that looks easy, but i can't find the answer..

I have 2 Excel documents, the first one contains the Order number and the quantity ordered, and the other contains the same Order number, and the quantity delivered.

I want to calculate for each order number : sum(quantity delivered)/sum(quantity ordered).

My problem is that i Don't know how to make QlikView understand "For each order number".

I hope i'm clear enough, if that's not the case, i would precise with pleasure !

Thank you in advance for answering.

Thomas.

3 Replies
Highlighted
Creator II
Creator II

Re: "For each"

Qlik will automatically make a relation between two different sources if it is having similar field name,if not,you can link by using renaming fields or joining concatenation methods.

Highlighted
Contributor
Contributor

Re: "For each"

Yes this works well, QlikView makes the relation. But still, it doesn't give me the precision "for each order number".

With this relation, i can calculate : sum of all order quantity/sum of all delivered quantity.

But this is not what i want, because, after that, i want to obtain the proportion of "order quantity that are equal to the delivered quantity".

For example i thought about this :

"For each" [Order number], if(sum([ordered quantity])=sum([delivered quantity]),1,0) as [test]

count([test]=1)/count([test]=0)

 

This would give me the pourcentage of Order quantity that are equal to the delivered quantity, but i need to know how to write "for each".

I hope it's clearer this time.

Thank you in advance for any answer,

Thomas.

 

Highlighted
Digital Support
Digital Support

Re: "For each"

Not sure if the following Design Blog will help or not:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

If you want to search further in this area, use the following link, there are over 700 posts and most are how-to related:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.