Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to use these excel symbol conditions in Qlikview?

Hello Experts,

Please can anyone help on this.

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

Thanks in advanced

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

2018-07-20 11_49_29-Wingdings & Webdings Font Icon Character Map (Printable Cheat Sheet) — The Sprea.png

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:

2018-07-20 11_54_55-Edit Expression.png

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

2018-07-20 11_56_07-Chart Properties [].png

The second named # with this expression:

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

2018-07-20 11_49_46-Edit Script [C__Users_pts_Documents_Linest Symbol.qvw_].png

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

2018-07-20 11_49_29-Wingdings & Webdings Font Icon Character Map (Printable Cheat Sheet) — The Sprea.png

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:

2018-07-20 11_54_55-Edit Expression.png

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

2018-07-20 11_56_07-Chart Properties [].png

The second named # with this expression:

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

2018-07-20 11_49_46-Edit Script [C__Users_pts_Documents_Linest Symbol.qvw_].png

Anonymous
Not applicable
Author

Thank you Petter.

Its working.You are give good suggestion to me.