Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
anjali0108
Contributor II

Rank in set analysis

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.

6 Replies
MVP
MVP

Re: Rank in set analysis

Could you share your working sample qvw?

anjali0108
Contributor II

Re: Rank in set analysis

Sorry ,i cant share any sample data.

MVP
MVP

Re: Rank in set analysis

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

anjali0108
Contributor II

Re: Rank in set analysis

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

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

Life is so rich, and we need to respect to the life !!!

Re: Rank in set analysis

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.

Community Browser