topic Re: Percentile. Heat map in QlikView

Percentile. Heat map

rdsuperlike — Tue, 13 Oct 2015 21:34:02 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

Re: Percentile. Heat map

rdsuperlike — Tue, 13 Oct 2015 23:27:48 GMT

gwassenaar‌---i posted my question again with a sample. Hope it is clearer now.

Re: Percentile. Heat map

settu_periasamy — Wed, 14 Oct 2015 03:01:03 GMT

Hi,

Check the attachment.

Re: Percentile. Heat map

rdsuperlike — Wed, 14 Oct 2015 04:43:09 GMT

Can you please explain your chnages? I see that u added aggr to the expression. But what did u do in colormix wizard?

Re: Percentile. Heat map

rdsuperlike — Wed, 14 Oct 2015 05:09:47 GMT

Also, I want the Qty to be displayed as cell value and the colors indicating the percentile...

for eg: for 5/19 step37 the cell value should be 11 and color of the cell should be light green (since it indicates 12%)

I think in colormix2 u have used the percentile from the column name..right? i tried to put the expression into variable and then substituted the cariable in the colormix2 equation but it messed up.

can you explain your colormix2 equation too? did u generate it through colormix wizard?

Re: Percentile. Heat map

settu_periasamy — Wed, 14 Oct 2015 05:19:25 GMT

I added the label name (percentile) instead of the lengthy expression. So, it will apply you same value the background color also. You are using the same expression in the Colormix2 also.

Re: Percentile. Heat map

Anonymous — Wed, 14 Oct 2015 05:36:37 GMT

Hi ,

When your are using a cross table the aggr function may effects different dimensionality . i think it is creating a change in the Percentile.

Thanks ,

Bunny

Re: Percentile. Heat map

settu_periasamy — Wed, 14 Oct 2015 05:45:45 GMT

Hi,

is that working as you expected or do you need any other thing?

Re: Percentile. Heat map

rdsuperlike — Wed, 14 Oct 2015 05:49:47 GMT

Its working.

But i want as below:

I want the Qty to be displayed as cell value and the colors indicating the percentile...

for eg: for 5/19 step37 the cell value should be 11 and color of the cell should be light green (since it indicates 12%)

Re: Percentile. Heat map

rdsuperlike — Wed, 14 Oct 2015 06:17:48 GMT

Its working.

But i want as below:

I want the Qty to be displayed as cell value and the colors indicating the percentile...

for eg: for 5/19 step37 the cell value should be 11 and color of the cell should be light green (since it indicates 12%)

Re: Percentile. Heat map

Anonymous — Thu, 16 Feb 2017 17:33:20 GMT

Hi ,

If i want to show percentile as 10-20%,20-30%,30,40%.........90-100%.?

How i can achieve this.

Can you help me on this.