topic Re: Help in visualization with Rank and Pick in QlikView

Help in visualization with Rank and Pick

rcandeo — Thu, 18 Aug 2016 13:38:35 GMT

I have this application where I see fixed calculations using set analysis for a selected client.

My problem is that I need to put client name on the top, instead of 3 dimension numbers used to format.

Something like this:

NAME

Ranking Rank Change Premium & Change

Overall 10 5 20%

Insurance 8 0 13%

Binding 25 18 -15%

Anyone can give me a hint please?

Re: Help in visualization with Rank and Pick

settu_periasamy — Sat, 20 Aug 2016 18:35:36 GMT

May be you can create one text object and put it in top of that header with 'Layer' on top in the Layout Tab

Re: Help in visualization with Rank and Pick

vishsaggi — Sat, 20 Aug 2016 18:55:59 GMT

I am not sure if you are looking something like this ? Let me know will this suffice your request if not use Sethu's tip.

Re: Help in visualization with Rank and Pick

rcandeo — Mon, 22 Aug 2016 12:22:58 GMT

Can you show me how did you do this please?

Re: Help in visualization with Rank and Pick

crusader_ — Mon, 22 Aug 2016 12:41:19 GMT

Drag and drop in Pivot table. Pick the field and move it to top-right until Blue arrow become horizontal then drop it.

Hope this helps.

/Andrei

Re: Help in visualization with Rank and Pick

rcandeo — Mon, 22 Aug 2016 12:48:42 GMT

I´ve done that, but I don´t know why after doing this, I see only the column 3, the others disappear

Re: Help in visualization with Rank and Pick

effinty2112 — Mon, 22 Aug 2016 12:52:58 GMT

Hi Robson,

In your pivot table add customer as a dimension and drag it to the top of the chart until the blue arrow goes horizontal then release the mouse button.

In the presentation tab select Customer in the Dimensions and Expressions list then select centre alignment for Data(Text).

Cheers

Andrew

Re: Help in visualization with Rank and Pick

vishsaggi — Mon, 22 Aug 2016 14:00:53 GMT

I have done nothing, just added Name in the caption with Right alignment and unchecked the special icons in caption tab. This is just a work around. There might be some other way, which i am not sure. But if it suffice your requirment yes you can use this way.

Re: Help in visualization with Rank and Pick

rcandeo — Thu, 25 Aug 2016 11:17:44 GMT

I´ve tried already. and I don´t know why after doing this, I can only see the 3th column of my 3 dimensions

Re: Help in visualization with Rank and Pick

sunny_talwar — Thu, 25 Aug 2016 11:35:35 GMT

Check the attached out....

I have only fixed the 1st two expressions, you can implement the same change to others

Aggr(YourExpression, Dim, [Broker Group Name])

Re: Help in visualization with Rank and Pick

sunny_talwar — Thu, 25 Aug 2016 12:26:05 GMT

Might as well do the whole thing

Re: Help in visualization with Rank and Pick

sunny_talwar — Thu, 25 Aug 2016 12:30:56 GMT

The problem is that the Rank function is used for unpivoted ranking, whereas we need to use HRank for Horizontal ranking in a pivot table (when a certain dimension is pivoted) -> HRank ‒ QlikView. But not sure why, but I was running into issues using that. So in order to fool the chart into believing that we have not pivoted but using the Aggr function.

Also tried to fine tune your chart by removing the third dimension (text) and incorporated that into Dim using Pick() function.