Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
johngouws
Partner
Partner

Bottom x Clients

Good morning.

I previously received assistance with this question, But like everything, the goal posts keep moving!

In the attached example there are 2 objects which show the top or bottom x Clients, based on a value.

The bottom objects show the same principle, but based on a start and end date. I am however finding an issue with finding the bottom x Clients in the 'Orange' object. What I am finding is that when I select the entire date range the, the values are correct. However, if I select a smaller date range, the ranked values returned are not correct.

I thank you for a possible solution in advance.

John

1 Solution

Accepted Solutions
jpenuliar
Partner
Partner

Hi John,

Have a look at attached, What i've noticed was the date values in your variables are not same format to your date field,

Not sure exactly where the error on your object is, so i done a new one instead.

see if this works for you.

View solution in original post

5 Replies
jpenuliar
Partner
Partner

Please see attached:

jpenuliar
Partner
Partner

I've basically translated your IF expression into a Set Analysis.

to achieve the bottom rank with variable dates.

johngouws
Partner
Partner
Author

Hi Jonathan,

Thank you for the example.

I changed the calculated dim and expression to set analysis, but it is still returning incorrect number of Amounts.

In the attached example the start and end variable is set to May 2014, but looking at the chart, it is returning Amounts outside of that selection!

I would expect it only to return Amounts for May.
Please could you point out anywhere else I am going wrong?

Thank you  - John

jpenuliar
Partner
Partner

Hi John,

Have a look at attached, What i've noticed was the date values in your variables are not same format to your date field,

Not sure exactly where the error on your object is, so i done a new one instead.

see if this works for you.

View solution in original post

johngouws
Partner
Partner
Author

Hi Jonathan,

Date format! It is working perfectly for Top and Bottom in this example now.

I am going to look at the source in the AM.

Thank you very much.

John