Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I cannot follow your links?
Are they correct?
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.
Hi,
I will definitely look more deeply into this.
Thanks for the input.
Kind regards, Jonathan