Showing correct percentage in Charts

[#1]

Hi,

I am very new to the Qlikview tool and trying to build a report. I have an excel table with many columns but i want to make a chart with two columns, "market regions" and "performance percentage (%)".

I have selected "Market units" as my dimentsion and AVERAGE of "Performance percentage",

Problem is that when i select Pivot table, it shows the corect average of percentage values (for example 84.5% for the first region)

but when i select any chart for graphical representation, it shows 8.4% with the same number foramt settings.

Please help to locate what format have to be corrected and where.

Thanks!

[#2]

Can you share you application ????

[kaushalview]

Hi

Asad

Sppose u can show ur calculated field value in gaugechart or bar chart like any chat ,first u set the chart Property Number---> Fixed decimal(2) ------>Formatepattern (write the value as u can set for show in percentage )----> chack show percentage indicator.

for ur problem set formate pattern like this in screen shot

Formate pattern:#.####0,00%

i attached screen shot

Regards

Kaushal Mehta

[kaushalview]

Hi,

I attached img

plz see

regards

Kaushal Mehta

[#5]

Hi again,

Thanks for the quick replies. I changed the format as advised but results are the same. I am attaching the image to describe the difference in more detail. First i made the pivot, and then simply cloned it to make the chart, but it did not retur the same values as picot.

KRs/Asad

[#6]

Hi Ashwin,

Would it be enough to attach the QV file? bkoz the excel file linked is like 8+ MB.

KRs/Asad

[kaushalview]

Hi,

Asad

its working in my application.can u plz send me ur application.

so its better to solve ur problem.

Regrads

Kaushal Mehta

[#8]

Hi again,

Something went strange, when i checked again today, it is working fine, seems like i was quite tired yesterday

Thanks for the help 🙂 i will sure come back if have any problems.

KRs/Asad

[kaushalview]

hi

asad

Plz verify my post there is one option in community to verify.

Regards

Kaushal mehta

[#10]

Hi,

Just a question, the chart worked with the same old settings without any change. Should I verify your post anyway as i have not applied ur settings?

KRs/Asad