Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
taraolsen
Contributor
Contributor

Drill down group does not work properly on heatmap in Access Point


I have a heat map that has the drill down group Vendor-> description-> code description-> distribution center -> location . The drill through works great on the desktop ( there is a minor glitch with the other grouping but this disappears on SP10) , but gets glitchy in access point.

In Access point , the heatmap appears and shows me vendor ( just like it should), but when I click on a vendor name  it shows me one box with the vendor name.... not the next level which is description.

If  I click on the one box that appears it goes back to the vendor heatmap and then I can click on a vendor name and on click  it will go to the description level ...... so it does go there.. eventually , but not in the proper path.

This also seems to be occuring in the 3D charts also , although it is not happening in standard bar charts.

Any help would be great!

7 Replies
qlikviewwizard
Master II
Master II

Hi tara olsen,

Please attach the sample application to demonstrate your issue. Thank you.

taraolsen
Contributor
Contributor
Author

Hi qlikview wizard -

I can't attached anything that would be helpful, becuase when its on my desktop it works perfectly fine. The issue only arises on the  web version ( access point). It works fine  on the desktop.

Thanks,

Tara

krishna_2644
Specialist III
Specialist III

It can be solved only when we see the expressions or the entire heat map.

So please post the qvw.

Thanks

taraolsen
Contributor
Contributor
Author

The primary expression is basic

SUM ([Item Extended Cost])

.. the color expression was created using the colormix wizard and is

ColorMix1 ((1+Sign(2*(Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000)-RangeMin (top(total Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000),1,NoOfRows(total))))/(RangeMax (top(total Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000),1,NoOfRows(total)))-RangeMin (top(total Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000)-RangeMin (top(total Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000),1,NoOfRows(total))))/(RangeMax (top(total Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000),1,NoOfRows(total)))-RangeMin (top(total Sum ([Inventory Adjustment Qty])/(Sum (Lines)/10000),1,NoOfRows(total))))-1))))/2, ARGB(255, 0, 255, 0), ARGB(255, 255, 0, 0))

I am trying to uplaod the qvw, but it is telling me I do not have permssion to upload ( I think because I have never synched the desktop  license) . So I need to get the copy off the server.


krishna_2644
Specialist III
Specialist III

Hi tara,

What i meant was , its only possible to look the problem when we see the App on the Whole ,as you said it works fine on your desktop but not on accespoint?

qlikviewwizard
Master II
Master II

Hi,

Please attach the file as shown in the screen.

Thank you.

Capture.JPG

taraolsen
Contributor
Contributor
Author

I dont have that as an option. I tried to expand my screen but I have its still dont get it .... could it be a permision thing ?

screen.JPG