Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sqlpuzzle
New Contributor II

Percentage Growth

Hi,

I am trying to find the percentage change.

I have a slider that selects the year range. And a Line chart. I need to display the percentage change of the measure as a KPI.

What is the formula to do that?

Thanks

Tags (1)
1 Solution

Accepted Solutions

Re: Percentage Growth

What would be the growth number you would want to see? from 1976 to 1989? May be this

=Num(Only({<Year = {$(=MaxString(Year))}>}Population)/Only({<Year = {$(=MinString(Year))}>}Population) - 1, '##.00%')

Note: I had to use MaxString and MinString because your year field is a text, rather than a number. Convert it to number and you should be able to use Max and Min instead of MaxString and MinString

7 Replies
ahaahaaha
Honored Contributor

Re: Percentage Growth

Hi,

May be like as at attached file.

Regards,

Andrey

Frank_Hartmann
Honored Contributor

Re: Percentage Growth

for %change try with this expression:

=(Num(Population,'###,##0') - above(num(Population,'###,##0')))/(Num(Population,'###,##0'))

sqlpuzzle
New Contributor II

Re: Percentage Growth

Andrey,

The expression you gave is very handy.

I put that expression into the Textbox object with ID 'TX01'. It showed just a -, I guess some placeholder for null values.

I am looking for getting it as a KPI in the text box. Not as another chart.

Thanks

sqlpuzzle
New Contributor II

Re: Percentage Growth

Hi Frank,

I tried the expression in the TX01 object and it did not work. Is it a different formula for the TextBox?

Thanks

Frank_Hartmann
Honored Contributor

Re: Percentage Growth

in a textbox you are showing only one singele value!

if you are setting up the range by slider how should the % changed be applied!

means, which % change do you want to show? from beginning of the range to the end of the range?

can u give more details?

Re: Percentage Growth

What would be the growth number you would want to see? from 1976 to 1989? May be this

=Num(Only({<Year = {$(=MaxString(Year))}>}Population)/Only({<Year = {$(=MinString(Year))}>}Population) - 1, '##.00%')

Note: I had to use MaxString and MinString because your year field is a text, rather than a number. Convert it to number and you should be able to use Max and Min instead of MaxString and MinString

sqlpuzzle
New Contributor II

Re: Percentage Growth

Growth% from the Start to End based on the Slider.

((Population at End Slider) - (Population at Start Slider))/ (Population at Start Slider)


Community Browser