topic Re: SetAnalysis in Qlik Learning Discussions

SetAnalysis

nikhilgarg — Thu, 21 Aug 2014 09:05:50 GMT

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)

Re: SetAnalysis

Thu, 21 Aug 2014 09:09:02 GMT

Hi Nikhil,

Can you please attach your qvw sample here?

Thanks
Sabal

Re: SetAnalysis

nikhilgarg — Thu, 21 Aug 2014 09:16:40 GMT

HEy , I have attached the qvw file , please have a look on it and let me know the solution

Re: SetAnalysis

senarath — Thu, 21 Aug 2014 09:22:44 GMT

Hi,

You have used double quotation where as you should use single quotation for Disaster Type

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

Double Quotes are used when putting search criteria.

thanx

Re: SetAnalysis

Thu, 21 Aug 2014 09:26:03 GMT

Hi Nikhil,

Cant you create a bar chart with Disaster.Type in Dimensions and expression as Sum(Disaster.Killed) and the sort the Dimension Disaster.Type with Y-value Ascending.

Let me know if this helps.

Thanks

Sabal

Re: SetAnalysis

nikhilgarg — Thu, 21 Aug 2014 09:27:10 GMT

HEy,

It does not make any difference. I tried with single quotation also.

Re: Re: SetAnalysis

Thu, 21 Aug 2014 09:28:18 GMT

Refer BlockChart tab in the container.

Re: Re: SetAnalysis

nikhilgarg — Thu, 21 Aug 2014 09:39:19 GMT

HEy Sabal ,

I tried the way u told me to do and it does help me. Thanx for that. But what if i want to do the same with rank(). Why it is not giving same result with rank(). Can you help me providing solution with rank() ??

Re: Re: SetAnalysis

Thu, 21 Aug 2014 13:45:42 GMT

Hi Nikhil,

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

gives you the correct values(i.e., Top 10 Disaster Types based on sum of Disaster Killed.

However to get the values in increasing order, you would have to use the sort order.

So either you can sort it by Y-value as Ascending for the expression or

use below expression as sort order for Display Type:

Rank(-sum(Disaster.Killed),4)

Hope this clarifies.

Thanks

Sabal

Re: Re: SetAnalysis

nikhilgarg — Fri, 22 Aug 2014 04:50:44 GMT

HEy Sabal ,

Sum(Disaster.Killed) and Sum({$<Disaster.Type = {"=rank(Sum(Disaster.Killed),4)<= 10"} > }Disaster.Killed) both are working fine provided we check the option y vale ascending in sort tab. But exactly what dis Rank() does , i am still not clear about this. Thanx

Re: SetAnalysis

Mon, 25 Aug 2014 06:38:50 GMT

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

Re: SetAnalysis

nikhilgarg — Mon, 25 Aug 2014 07:14:53 GMT

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.

Re: Re: SetAnalysis

Mon, 25 Aug 2014 07:30:16 GMT

Hi Nikhil,

Please refer attached sample qvw for the explanation.

Thanks

Sabal

Re: Re: SetAnalysis

nikhilgarg — Mon, 25 Aug 2014 07:34:59 GMT

Hey ,

where is the attachment ??

Re: Re: Re: SetAnalysis

Mon, 25 Aug 2014 10:23:35 GMT

Hi Nikhil,

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

Anyways attaching it again here.

Thanks

Sabal

Re: Re: Re: SetAnalysis

nikhilgarg — Mon, 25 Aug 2014 10:29:52 GMT

HEy Sabal,

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

Re: Re: Re: SetAnalysis

Mon, 25 Aug 2014 14:59:05 GMT

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

Re: Re: Re: SetAnalysis

nikhilgarg — Tue, 26 Aug 2014 04:21:45 GMT

Hey,

YEah this helps thanks.

Re: SetAnalysis

Wed, 27 Aug 2014 10:17:03 GMT

Hi Nikhil,

Please close this thread.

Thanks

Sabal

Re: SetAnalysis

nikhilgarg — Wed, 27 Aug 2014 10:30:59 GMT

how can i close the thread ??