Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rdsuperlike
Contributor

heat map-percentile

I am trying to calculate percentile and use colormix wizard.

I am using rank function here.

When i use it on straught table it works fine. But as soon as I drag the blue arrow on the column(steps) and put it horizontally, it messes up.

I have attcahed the example and qvw.

I want pivot table with two dimensions as the crosstab.

Date Steps 40 39 38 37 35------ and so on

1/5

2/5         Qtys in the cell value and percentile values for colors

3/5

4/5

Any help is appreciated