Heat map in Qlikview

[vireshkolagimat]

Dear All,

I am trying to create heat map using pivot table with below mentioned calculated dimensions and metric.

Customer  =aggr(if(rank(aggr(sum(SalesValue*SalesQty), CustomerCode) <= $(vTopNHM)), CustomerName),CustomerName)

products  =aggr(if(rank(aggr(sum(SalesValue*SalesQty), ProductCode) <= $(vTopNHM)), ProductCode),ProductCode)

expression  sum(SalesValue*SalesQty)

I am using a variable in the input box to provide the number of customer information the user want to see. But however after entering the number in input box, the chart is not updating. It is showing all customer information.

Any suggestions where i am going wrong ?

Thank you.

Regards,

VK

[sunny_talwar]

Top 15 customer? but you have a calculated dimension for top products also, right?

[sunny_talwar]

Pivot table sorting will always be challenging... will try to address after we fix the other part

[vireshkolagimat]

thank you. Please let me know once you have updates.

[vireshkolagimat]

yes i have calculated dimension for both but i need the customer based on sales value. Need not to sort on product dimension.

[sunny_talwar]

Not talking about the sort by product... all I am asking is why is product a calculated dimension when you don't want top 5 or 15 products?

[vireshkolagimat]

The reason is when i looking at the top sales, i also want to know that which products are contributing that sales.

I need both top customer by sales value in descending order and products which are contributing those sales.

Please let me know if i am not clear.

thanks

[sunny_talwar]

But you want to see all products that are contributing it, right? not just the top 10 or top 15?

[vireshkolagimat]

Yes sunny. If i enter 10 in the input box, it should give me the top 10 customers by sales and products which are contributing that sale.

[sunny_talwar · Accepted solution]

Here you go

[vireshkolagimat]

I will check and will update you.

Thank you so much.