How to use these excel symbol conditions in Qlikview?

[Anonymous]

Hello Experts,

Please can anyone help on this.

Iam attached a file for calculation of Linest function with Average function.

Thanks in advanced

[petter · Accepted solution]

You can create a Pivot Table and use the R# and Date as dimensions. The Date dimension you will have to drag so it displays horisontally instead of vertically. You will have two expressions:

The first with the label =' ' with this expression:

and you will have to set the "Display Options" / "Representation" to "Image" in the dropdown as shown below:

The second named # with this expression:

If( ColumnNo(), Sum(#) , Alt( Num( LINEST_M(Date,#) ,'0.0000000','.',',') ,0 ) )

[Anonymous]

Thank you Petter.

Its working.You are give good suggestion to me.