topic Re: Heat map in Qlikview in QlikView

Heat map in Qlikview

vireshkolagimat — Tue, 08 May 2018 09:50:23 GMT

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,

Re: Heat map in Qlikview

sunny_talwar — Tue, 08 May 2018 11:40:41 GMT

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

Re: Heat map in Qlikview

vireshkolagimat — Tue, 08 May 2018 13:15:40 GMT

Hi Sunny,

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

Regards,

Viresh

Re: Heat map in Qlikview

sunny_talwar — Tue, 08 May 2018 13:24:41 GMT

Envision something like this?

Re: Heat map in Qlikview

vireshkolagimat — Tue, 08 May 2018 13:58:32 GMT

Yes

Re: Heat map in Qlikview

sunny_talwar — Tue, 08 May 2018 14:00:10 GMT

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

Re: Heat map in Qlikview

vireshkolagimat — Tue, 08 May 2018 14:09:23 GMT

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.

Re: Heat map in Qlikview

sunny_talwar — Tue, 08 May 2018 14:23:28 GMT

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?

Re: Heat map in Qlikview

vireshkolagimat — Tue, 08 May 2018 14:28:49 GMT

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

Re: Heat map in Qlikview

vireshkolagimat — Tue, 08 May 2018 14:30:15 GMT

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

Re: Heat map in Qlikview

sunny_talwar — Tue, 08 May 2018 14:36:25 GMT

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

Re: Heat map in Qlikview

sunny_talwar — Tue, 08 May 2018 14:36:48 GMT

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

Re: Heat map in Qlikview

vireshkolagimat — Wed, 09 May 2018 06:23:18 GMT

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

Re: Heat map in Qlikview

vireshkolagimat — Wed, 09 May 2018 06:27:04 GMT

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

Re: Heat map in Qlikview

sunny_talwar — Wed, 09 May 2018 08:59:18 GMT

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?

Re: Heat map in Qlikview

vireshkolagimat — Wed, 09 May 2018 11:15:30 GMT

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

Re: Heat map in Qlikview

sunny_talwar — Wed, 09 May 2018 11:18:10 GMT

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

Re: Heat map in Qlikview

vireshkolagimat — Wed, 09 May 2018 13:50:45 GMT

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.

Re: Heat map in Qlikview

sunny_talwar — Wed, 09 May 2018 14:28:25 GMT

Here you go

Re: Heat map in Qlikview

vireshkolagimat — Wed, 09 May 2018 15:13:56 GMT

I will check and will update you.

Thank you so much.