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: 
Jonathan_Alm
Partner - Creator
Partner - Creator

Aggr and set analysis

Hi,

I have a problem with combining set analysis, aggr and dividing two expressions.

I need this to be able to create my heatmap.

I am following example on this page:

https://qlikfreak.wordpress.com/2014/03/09/heat-map/

The expression I use and that fails is:

=$(=max(aggr(sum(AbsenceTime)/sum(TimeTableMinutes),AbsenceDate)))

The expression returns: Error: Garbage after expression: ","

If I remove "$(=" And just enter:

=max(aggr(sum(AbsenceTime)/sum(TimeTableMinutes),AbsenceDate)))


I get the correct value: 0,094 which is the date with the highest absence percentage based on TimeTableMinutes.


Also If I remove the "sum(TimeTableMinutes)" the expression is accepted:

=$(=max(aggr(sum(AbsenceTime),AbsenceDate)))



However I need it to be "pre-calculated” outside the pivot table and not for each cell, therefore the "$(=" seems necessary

Does anyone have a suggestion on how to get pass this problem?

Kind regards, Jonathan

12 Replies
Jonathan_Alm
Partner - Creator
Partner - Creator
Author

Hi,

I cannot follow your links?

Are they correct?

Anonymous
Not applicable

If you go to qlik.help.com and click on QV or QS, depending on the product, and the select "February 2018" from the version list, you should be able to search for the keywords at the end of the links provided to pull up the pages since this version is out of release and now a production version.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/dollar-sign-ex...

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/dollar-sign-expansio...

Jonathan_Alm
Partner - Creator
Partner - Creator
Author

Hi,

I will definitely look more deeply into this.

Thanks for the input.

Kind regards, Jonathan