Question related to RANK function in a line graph

Fri, 16 Jan 2015 11:03:49 GMT

Hi,

The below is the data that I have loaded onto my QLikView dashboard

Year, Unit, Client, Premium
2013, U1, C1, 1000
2013, U2, C2, 800
2013, U3, C3, 600
2013, U1, C3, 1100
2013, U2, C1, 700
2013, U3, C2, 500
2014, U1, C1, 400
2014, U2, C2, 300
2014, U3, C3, 250
2014, U1, C3, 1300
2014, U2, C1, 1200
2014, U3, C2, 100

Using the above data, I need to create a RANK for each client with in the YEAR and UNIT based on the premium. Once the rankings are created, I need to select a client to show a line graph which shows me to rank movement for that client across years (I need to show one line per unit). This way I can analyse how the client rank is behaving across different units in multiple years.

Attached QVW has the data and also explains the problem that I am facing. Note selection of a client is mandatory to show the line graph.

I would prefer to have the solution to be acieved by means of having this done in a line chart but if we need to make any script changes, I would consider that to be last option.

Thanks in avance for all your help.

Regards,

Murali

Re: Question related to RANK function in a line graph

Anonymous — Fri, 16 Jan 2015 14:51:03 GMT

Hello,

Instad of

rank(sum({<Client={"*"}>} Premium),4)

try

rank(sum(Premium),4)

You select a client but chart doesn't respond to that since it still thinks like you want to select all client due to set analysis.

Serhan

Re: Question related to RANK function in a line graph

Mon, 19 Jan 2015 14:19:26 GMT

I tried this option but it didn't work.

topic Question related to RANK function in a line graph in QlikView

Question related to RANK function in a line graph

Re: Question related to RANK function in a line graph

Re: Question related to RANK function in a line graph