heat map-percentile

rdsuperlike — Tue, 13 Oct 2015 21:41:46 GMT

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

topic heat map-percentile in QlikView