topic Re: Rank in set analysis in QlikView

Rank in set analysis

anjali0108 — Wed, 01 Mar 2017 05:05:59 GMT

Hi experts,

I am using the below expression in qlikview but < is not giving me correct results,

how can i achieve the less than equal to value without any errors.

=aggr(sum({<Rank = {"<= $(=aggr((round(count(HostName)/2) - count({<UpTime = {'1'}>}HostName)),Hrs)+1) >1"}>}UpTime),Hrs)

Thanks in advance.

Re: Rank in set analysis

tresB — Wed, 01 Mar 2017 05:11:38 GMT

Could you share your working sample qvw?

Re: Rank in set analysis

anjali0108 — Wed, 01 Mar 2017 05:40:59 GMT

Sorry ,i cant share any sample data.

Re: Rank in set analysis

tresB — Wed, 01 Mar 2017 05:45:10 GMT

If you want to be helped, you have to help too. May be the following link can help you :Preparing examples for Upload - Reduction and Data Scrambling

Re: Rank in set analysis

anjali0108 — Wed, 01 Mar 2017 05:48:51 GMT

Hi Tresco,

I know that but the only problem is that I have posted this doubt on behalf of my colleague and he only is not sharing data with me,so how would I post it here.

Anyways,thanks ....

Re: Rank in set analysis

Anil_Babu_Samineni — Wed, 01 Mar 2017 06:30:01 GMT

No need to share your real data may be go scramble data or own inline data with expected output, Because your question is UN-filled. Anyhow, At least try to explain business requirement to do the offer

Re: Rank in set analysis

sunny_talwar — Wed, 01 Mar 2017 09:44:18 GMT

The expression makes so sense at all and I will be amazed if it is giving any result. I would suggest sharing more information as to what exactly this is intended to do.