topic Re: Ratios in QlikView

Ratios

parvez933 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Ratios

agni_gold — Sat, 09 Feb 2019 08:18:05 GMT

Can you attach your qvw ?

Re: Ratios

parvez933 — Sat, 09 Feb 2019 08:39:18 GMT

PFA

Re: Ratios

agni_gold — Sat, 09 Feb 2019 08:43:08 GMT

What output you want ?

Re: Ratios

parvez933 — Sat, 09 Feb 2019 09:02:03 GMT

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

Re: Ratios

agni_gold — Sat, 09 Feb 2019 09:32:00 GMT

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

Re: Ratios

parvez933 — Sat, 09 Feb 2019 09:50:05 GMT

Re: Ratios

agni_gold — Sat, 09 Feb 2019 10:01:38 GMT

PFA ,

Re: Ratios

agni_gold — Sat, 09 Feb 2019 10:30:43 GMT

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

Re: Ratios

parvez933 — Sat, 09 Feb 2019 10:33:48 GMT

Looking into it. Please give me some time

Re: Ratios

parvez933 — Sat, 09 Feb 2019 10:49:19 GMT

Thank You Agni_gold!
For your help! I was rounding for this from the last 3 days.