Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Using Concat Aggr in a Heatmap

Hi All,

I have the following expression

=Concat(Customer & ' - ' & Num(Aggr($(e.tickets), Customer), '#,##0'), chr(10), -Aggr($(e.tickets), Customer))

Which returns the correct number of tickets for each Customer, However when I add to a heatmap and hover over the day, it will not display the Qty's for each Customer, any ideas.

2018-01-04_1435.png

if I add the above expression in a text object it works fine

2018-01-04_1436.png

1 Solution

Accepted Solutions
sunny_talwar

Try this

=REPEAT(CHR(13),2) & REPEAT('-',10) & chr(13) &  $(e.tickets) & ' Tickets Created' & CHR(13) &

Concat(DISTINCT If(Len(Trim(Aggr($(e.tickets), Customer, Year, Weekday, Week))) > 0, Customer & ' - ') & Num(Aggr($(e.tickets), Customer, Year, Weekday, Week), '#,##0'), chr(10), -Aggr($(e.tickets), Customer, Year, Weekday, Week))

View solution in original post

13 Replies
sunny_talwar

If you just use this as your expression... does it show you the numbers?

Num(Aggr($(e.tickets), Customer), '#,##0')

rustyfishbones
Master II
Master II
Author

No i'm afraid not

sunny_talwar

What is behind this variable? $(e.tickets)

rustyfishbones
Master II
Master II
Author

COUNT (DISTINCT Ticket_No)

sunny_talwar

Does this work?

Num(Aggr(COUNT (DISTINCT Ticket_No), Customer), '#,##0')

rustyfishbones
Master II
Master II
Author

I will try it shortly, just running a reload on another document

rustyfishbones
Master II
Master II
Author

Hi Sunny,

That does not work either, as I said, this works fine in a text object

=Concat(Customer & ' - ' & Num(Aggr($(e.tickets), Customer), '#,##0'), chr(10), -Aggr($(e.tickets), Customer))


but then fails on the heatmap

sunny_talwar

May be you need to add Year, WeekDay, Week in your Aggr() function....

=Concat(Customer & ' - ' & Num(Aggr($(e.tickets), Customer), '#,##0'), chr(10), -Aggr($(e.tickets), Customer, Year, WeekDay, Week))

If this doesn't help, would you be able to share a sample?

rustyfishbones
Master II
Master II
Author

I tried that earlier today and it did not return the correct result.

But I will try again, if it does not work I will try share a reduced version of the App.