topic Re: How to use these excel symbol conditions in Qlikview? in QlikView

How to use these excel symbol conditions in Qlikview?

Anonymous — Fri, 20 Jul 2018 05:22:54 GMT

Hello Experts,

Please can anyone help on this.

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

Thanks in advanced

Re: How to use these excel symbol conditions in Qlikview?

petter — Fri, 20 Jul 2018 09:59:51 GMT

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 ) )

Re: How to use these excel symbol conditions in Qlikview?

Anonymous — Fri, 20 Jul 2018 14:22:11 GMT

Thank you Petter.

Its working.You are give good suggestion to me.