Ratios

[parvez933]

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

[agni_gold]

Can you attach your qvw ?

[parvez933]

PFA

[agni_gold]

What output you want ?

[parvez933]

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]

So whats the point , just divide the columns and get the ratio

[agni_gold · Accepted solution]

PFA , 

[agni_gold]

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

[parvez933]

Looking into it. Please give me some time