topic Re: Help need with a % calculation in QlikView

Help need with a % calculation

Thu, 04 Jun 2015 04:46:17 GMT

Hi Experts,

i have an issue with data while calculating the percentage.

the below two pivot table should show the same % value but, the second table is showing slighlty different data than the firat one. the correct data is the one in the first table. the expression used in both the table are given below. . i have several Rooms, but for example i have given only 2 Rooms.

Pivot Tbale1, in this Room is a dimension and Minute is Expression. and used Pivot option.

Minutes	Room1
0	15.75%
1-15	18.04%
16-30	15.30%

expression is =count(cases)/count(TOTAL Case)

this table should show the % based on the selction on Minutes, it should give the % of count in that particular Room. Minutes and Room is dimension and used one expression given below , then pivoted.

Minutes	Room1
0	16.20%
1-15	18.54%
16-30	15.73%

count(cases)/count(TOTAL<Room> Case)

please help... I am not able to find the cause of this difference in data.

Re: Help need with a % calculation

jagan — Thu, 04 Jun 2015 05:00:21 GMT

Hi,

Can you share sample file, so that it would be easier to analyse.

I think you need to use the Room dimension then only it will split accordingly. Since you are using same dimension in both the charts but different expression, I think you will get different results.

Regards,

Jagan.

Re: Help need with a % calculation

Thu, 04 Jun 2015 05:06:43 GMT

Hi jagan,

thanks for your reply. but sorry i am uanbel to share a sample app due different reasons.

ultimately both the expression shopulf give the same result. i need data to be represented like table 2. but for testing i created the table1. then only i found the difference.

What i need is on clicking 0 , the % of the count(cases ) for each and every Room should be diaplayed horizontally.

Re: Help need with a % calculation

jagan — Thu, 04 Jun 2015 05:20:41 GMT

Hi,

It is difficult to suggest, attach some sample data and your expected ouput.

Regards,

Jagan.

Re: Help need with a % calculation

help4qv123 — Thu, 04 Jun 2015 05:51:30 GMT

u can prepare a sample data . we r not asking you to send ur actual data. send sample data would not be a problem for.

Not able to analyses your requirement. If you need help then plz prepare a sample.