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]

Would you be able to share a sample to show the issue?

[vireshkolagimat]

Hi Sunny,

Please find the attached file and let me know  if you need any further details.

Regards,

Viresh

[sunny_talwar]

Envision something like this?

[vireshkolagimat]

Yes

[sunny_talwar]

I have attached the file with my previous response for you to look at. If you got what you wanted, please close the thread.

Best,

Sunny

[vireshkolagimat]

Hi, I tried to change the top customer count 15 but i am getting only 11 customer and 14 products.

can you please check it once.

Thank you.

[sunny_talwar]

Can you let me know what exactly is the expected output when 15 is selected? I mean which Product and Customers need to show up?

[vireshkolagimat]

and also i need to sort the data based on sales value. Currently it is not sorting the data and customer with highest sales should come first.

thank you

[vireshkolagimat]

Top 15 customers with highest sales and sorted in the descending order.