Solved: Re: Visualizing precentages - Qlik Community

Report Inappropriate Content · ‎2012-10-15

L.S.

Can someone help me please to determine the percentage of incidents linked to problems.
In this case it would be 60% linked and 40 % not linked.

I would like to visualizing precentage mountly in a line graph

I have attached an example qvw and xlsx

Thanks in advance,

Frans

Gysbert_Wassenaar · ‎2012-10-15

See example. Since there is no data for months I've used Date as dimension. If you want to show data per month you should add a Month field in the load script. You can calculate this with month(date#(Date,'DD-MM-YYYY'))

talk is cheap, supply exceeds demand

View solution in original post

Gysbert_Wassenaar · ‎2012-10-15

See example. Since there is no data for months I've used Date as dimension. If you want to show data per month you should add a Month field in the load script. You can calculate this with month(date#(Date,'DD-MM-YYYY'))

talk is cheap, supply exceeds demand

kaushiknsolanki · ‎2012-10-15

Hi find the solution in attached example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2012-10-15

Thank you for respons it was helpfull to solf the problem. Gr Frans.

Report Inappropriate Content · ‎2012-10-15

Thank you for respons it was helpfull to solf the problem. Gr Frans.