Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
parvez933
Creator
Creator

Ratios

Hi Everyone,

Can anyone help me with the required!

Here, I am attaching my files with the developed QVW.

In which I am trying to get ratio as calculated from the excel "CommDEFOA_RatiosAmeya"

Base/Source File: Book1

Which contains data from Jan-July, Aug, Sep, Oct, Nov, and Dec with two segments

1. Cycle

2. EMS

Developed app: Required_do.qvw

Expected/Required Output should match with: CommDEFOA_RatiosAmeya

Can anyone please help me with the required output in the file "CommDEFOA_RatiosAmeya"

Regards,

M. Parvez

1 Solution

Accepted Solutions
agni_gold
Specialist III
Specialist III

10 Replies
agni_gold
Specialist III
Specialist III

Can you attach your qvw ?
parvez933
Creator
Creator
Author

PFA

agni_gold
Specialist III
Specialist III

What output you want ?
parvez933
Creator
Creator
Author

Hi There!

There is an latency in the network, I was trying to post the clear picture on my 1st page. But it is not loading.

However, the story is

Book1 is a datasource which give 2 details Cycle and EMS related to the year, month, and week

What is need?

Exact copy of "CommDEFOA_RatiosAmeya.xls"

There are 3 tabs in above shared excel (CommDEFOA_RatiosAmeya) for each tab there is an condition such as

Philips 1--> There is a filter BU on QlikView where I have to select all except "US"

then I have to compare the Sales, Count DEFOA to the Split in the DEFOA category (which is done in the CommDEFOA_RatiosAmeya.xls)

Ex: Philips 1 page on excel(CommDEFOA_RatiosAmeya)

Year 2016-> Month November-> Week 47-> Sales 48--> DEFOA 24

The said 24 should be split according to the category and should give a outcome total of 24

such as Defect 12+Wrong 0+Missing 9+Damage 2+Notification 1=24

Same will be continued in all other tabs DI and IGT

agni_gold
Specialist III
Specialist III

So whats the point , just divide the columns and get the ratio
parvez933
Creator
Creator
Author

 
agni_gold
Specialist III
Specialist III

PFA , 

agni_gold
Specialist III
Specialist III

Is my attachment worked? if yes please accept as a solution
parvez933
Creator
Creator
Author

Looking into it. Please give me some time