Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

Calculating the slope

Hi Experts,

I am trying to get the slope of my report chart into a text box. I was unsuccessfull all the time.

Can someone please help me out with the same. Attached is the chart that I am working on.

Thanks advance for your help.

Regards,

Shyam.

7 Replies
amit_saini
Master III
Master III

Shyam,

Check this:

How to calculate regression line, slope ?

Thanks,

AS

shyamcharan
Creator III
Creator III
Author

Hi Amit,

Thank you very much for your quick response.

Not sure if my require ment is similar to the one in the example you have shown. Sorry if i am wrong.

The calculation that i have used is simple and the one in example has quite a complex secnario. I am trying to understand the example. But meanwhile if someone can quickly look at my dashboard and see if this can be implemented quickly.

I already spent 2 weeks on this and I know its like I am exhausted on this.

Sorry for my ignorance at this point of time...

I appreciate any further help on this.

Regards,

Shyam.

amit_saini
Master III
Master III

Shyam,

No worries I'm working on this.

Thanks,
AS

shyamcharan
Creator III
Creator III
Author

Thanks heaps Amit.

Its bit embarrassing at this point for me. It might be simple but not sure I am not able to get around my mind into this.

I appreciate your help on this.

Regards,

Shyam.

amit_saini
Master III
Master III

Like this????

shyamcharan
Creator III
Creator III
Author

Hi Amit,

Yes, I want to display the slope in the Text. But it has to be the slope including the expression that I have used in my chart.

shyamcharan
Creator III
Creator III
Author

Hi Experts,

Can anyone help me on this issue. It still remains outstanding in my worklist.

I am using an approximate value calculation method for now but it still is not accurate and at times varies from the actual value what the graph shows.

Any help here will be highly appreciated.

Thanks in advance.

Regards,

Shyam.