Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make line chart able to display trend line appear when i click on month = 7 ?

Hi All

I have a trend line , I like to make it able to display the trend line , when i click on month = 7.

Paul

14 Replies
paulyeo11
Master
Master
Author

Hi Robert

Thank you for sharing with me John explaination on SET analysis which is 3 year back.

Paul

sfatoux72
Partner - Specialist
Partner - Specialist

You're right, I worked on the reason why the calculation was not calculated for every month. I used internal expressions without modification thinking they were correct.

Here the expression with the internal correction of Kush and my reorganization:

If(sum({<month=>}STK_CLOSE) > 0 and sum({<month=>}STK_OPEN) > 0,

If(Mod(RowNo(),12) = 0, 12, Mod(RowNo(),12)) * 30

*

RangeAvg(Sum({<month=>}TOTAL <year> If([YearMonth] = YearStart([YearMonth]), STK_OPEN)), sum({<month>}STK_CLOSE))

/

RangeSum(Above(Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS+COGS_INT_)/1), 0, RowNo()))

)

Kushal_Chawda

Thanks Paul.

I am from India

paulyeo11
Master
Master
Author

Hi Kush

Are you work in India also ?

Paul

Sent from my iPhone

Kushal_Chawda

Yes, I work here in India.