SetAnalysis

[nikhilgarg]

Hello,

I have a Disaster Data having following Dimensions:

Disaster.Year , Disaster.Type , Disaster.Killed(Total Killed People for particular disaster) , StateData.Killed(Statewise killed people for particular disaster) , StateData.Location.

I want to create a bar chart showing the total killed people for different disasters in increasing order. i.e Total killed people by disaster1 , then disaster2 and so on.

I am using following set analysis but it is not giving me ryt output. Please solve the issue....

Sum({$<Disaster.Type = {"=rank(Sum(Disaster.Killed),4)<= 10"} > }Disaster.Killed)

[#2]

Hi Nikhil,

In this expression, the rank function helps to restrict the values to top 10(i.e., values <=10).

If there was no rank function, then to get the top 10 values you would have to use dimension limits.

If you are unclear, use Disaster.Name in the chart instead of Disaster.Type and another chart with Disaster.Name and expression as Sum(Disaster.Killed) and see the difference.

Hope I have explained myself.

Thanks

Sabal

[nikhilgarg · Accepted solution]

HEy Sabal,

I got the difference. While using Rank i get top 10 only and while using Sum(Disaster.Killed) i am not restricted to 10. THanx but can you also explain the mode used in rank() like 1,2,3,4.  I go through the manual of rank() also but cann't get the use of mode.

[#4]

Hi Nikhil,

Please refer attached sample qvw for the explanation.

Thanks

Sabal

[nikhilgarg]

Hey ,

where is the attachment ??

[#6]

Hi Nikhil,

I had attached the qvw(Rank-Sample) file.

Anyways attaching it again here.

Thanks

Sabal

[nikhilgarg]

HEy Sabal,

Can you tell me from where to download qlikview server ??

[#8]

Hi Nikhil,

Qlikview server is not a free download.

You have to purchase it(Qlikview server license) from Qlik or you can get it for free if you are an Alliance partner with Qliktech.

Hope this helps.

Thanks

Sabal

[nikhilgarg]

Hey,

YEah this helps thanks.

[#10]

Hi Nikhil,

Please close this thread.

Thanks

Sabal

[nikhilgarg]

how can i close the thread ??