Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

changing line chart measure to display in percentage, with 100% the highest

I am farely new to qlik sense, I have using a line chart. I usually display data formerly on excel, would want the Y-axis to display in percentage(with 100% being the highest) and the X-axis showing the month and trend as the line moves. i.e in some months the the selected item wouldn't reach a 100% and in other it reaches.

7 Replies
MVP
MVP

Re: changing line chart measure to display in percentage, with 100% the highest

What is your chart dimension and what are your chart expressions?

Not applicable

Re: changing line chart measure to display in percentage, with 100% the highest

Hi Sunny,

    The Dimension is based on months(a field) of the year while my measure is based on counts of a VALUE, but I put this in the measure(Num(sum([TICKET_ID_])/sum([TICKET_ID_]),'#,##0%') function box and everything becomes just a 100%.

Not applicable

Re: changing line chart measure to display in percentage, with 100% the highest

e.g If I have 50 Items for the month and 40 meets my condition that I set, I want the measure(line graph) displaying 80% of the condition met. Is it possible ??

MVP
MVP

Re: changing line chart measure to display in percentage, with 100% the highest

May be this:

Num(Sum([TICKET_ID_])/Sum(TOTAL [TICKET_ID_]),'#,##0%')

Not applicable

Re: changing line chart measure to display in percentage, with 100% the highest

Hi Sunny.
that code starts the percentile with -100, I want starting from % to 100%.
MVP
MVP

Re: changing line chart measure to display in percentage, with 100% the highest

Would you be able to share a sample to look at this?

Not applicable

Re: changing line chart measure to display in percentage, with 100% the highest

488042da4f1944dcb2d2407a172ed512.png

Hi sunny,

that's an image of it, I want the Y-axis  starting from 0% and 100% being the highest. e.g  If I have 50 Items for the month and 40 meets my condition that I set, I want the measure(line graph) displaying 80% of the condition met. Is it possible ??