topic Re: Top N Customers - Number Series with Step in QlikView

Top N Customers - Number Series with Step

Wed, 22 Apr 2015 16:12:01 GMT

Hello There!

I've created Top N Customers' Sales Chart based on an Input box of any number (say, 5, 10, 15 etc.). Now, I need to change it like a way that where I can input any number (say 50); then Top 50 Customers Data will be shown. Then with a Click to 'Next' Arrow, next Top 50 Customers' Data should be displayed.... and so on... Actually I want to have mechanism like the snap-shots given below:-

Can anyone suggest me how can I achieve that easily?

Thanks in Advance.

Sajjad.

Re: Top N Customers - Number Series with Step

Sun, 26 Apr 2015 17:34:11 GMT

Hello There!

Actually I wanted to have a page by page view (like mailbox) in a straight Table in a descending order.

Can anyone suggest any solution?

Thanks,

- Sajjad.

Re: Top N Customers - Number Series with Step

Sun, 03 May 2015 07:48:15 GMT

Hello!

Should I assume that this facility cannot be achieved?

Thanks,

- Sajjad.

Re: Top N Customers - Number Series with Step

petter — Sun, 03 May 2015 08:23:35 GMT

I think it can - although I have never tried exactly this - I think it can be achieved... let me see if I can give it a try

Re: Top N Customers - Number Series with Step

Gysbert_Wassenaar — Sun, 03 May 2015 10:39:22 GMT

See this blog post: YA(H)Q Blog: Paged charts in Qlikview

Re: Top N Customers - Number Series with Step

petter — Sun, 03 May 2015 10:47:35 GMT

I attached a sample application that this screenshot is from:

Re: Top N Customers - Number Series with Step

Sun, 03 May 2015 15:47:05 GMT

Dear Mr. Gysbert,

It's amazingly cool solution .... I hope this will work.

Thanks a lot!

- Sajjad.

Re: Top N Customers - Number Series with Step

Sun, 03 May 2015 15:49:42 GMT

Dear Mr. Peter,

I suppose I'm not finding the attachment. Will you please resend the Application attachment again!

Thanks,

- Sajjad.

Re: Top N Customers - Number Series with Step

Anonymous — Sun, 03 May 2015 15:54:16 GMT

See if this helps

Re: Top N Customers - Number Series with Step

petter — Sun, 03 May 2015 15:58:38 GMT

Strange ... I see my own attachement in the previous post - but here it goes again:

Re: Top N Customers - Number Series with Step

Sun, 03 May 2015 17:41:25 GMT

Dear Mr. Peter,

Thanks for the attachment (qvw) and I hope this will help. It's neat & crispy as I gone through it quickly!

Appreciate your effort a lot!

Regards,

- Sajjad.

Re: Top N Customers - Number Series with Step

Sun, 03 May 2015 17:59:00 GMT

Dear Mr. Michael,

Thanks for your qvw attachment for the solution.... however, while opening the qvw, it is asking for to recover the file. [screen-shot attached below]

Would appreciate if you suggest me further.

Thanks again,

- Sajjad.

Re: Top N Customers - Number Series with Step

Anonymous — Sun, 03 May 2015 18:10:32 GMT

I doubt it was created in a personal edition, but it was long ago, can't be sure. I just re-saved it in a licensed QV version, and re-attached into the same message. Try again.

If it doesn't help... I don't know. You need license for your QV to open the file. Worst, case, if nothing works, I'll describe the script and the front object's properties.

Re: Top N Customers - Number Series with Step

Mon, 04 May 2015 12:54:38 GMT

Dear Mr. Michael,

Thanks a lot for your effort.... but it didn't work.... same massage appearing .... asking for recovery...

Thanks again for your help.

- Sajjad.

Re: Top N Customers - Number Series with Step

Anonymous — Tue, 05 May 2015 11:49:55 GMT

OK, I'll describe in words then.

Here is the whole of this example:

Data:
LOAD
RowNo() as ID,
right(floor((rand()*100000)),2) as X,
money(rand()*1000) as Amount
AUTOGENERATE 1000;
// Assuming it must be sorted by X, then by ID
LEFT JOIN (Data) LOAD DISTINCT
ID,
X,
RowNo() as TableSortOrder
RESIDENT Data
ORDER BY X, ID;

The font end.

There are two variables:

- vPage (it shows the current page)

- vPageSize

There is an input box for vPageSize

There is a text box

The "text" there is an expression

='Page ' & vPage & ' of ' & ceil(count(distinct TableSortOrder)/vPageSize)

And, there are four buttons overlaying the text box, all use action set variable vPage, but with the different value. Button text in bold here:

|<< (go to the beginning) , sets value to 1

> sets value to =vPage+1 This button is enabled on condition

vPage<ceil(count(distinct TableSortOrder)/vPageSize)

< sets value to =vPage-1; it is enabled on condition vPage>1

>>| (go to the end) sets value to =ceil(count(distinct TableSortOrder)/vPageSize)

The last is the table itself. It is a straight table, first dimension is calculated

=aggr(if(rowno(total)>=(vPage-1)*vPageSize+1 and rowno(total)<=vPage*vPageSize,TableSortOrder), TableSortOrder)

As always with calculated dimension - check "suppress when value is null". The label of this dimension is "Order"

The other two dimensions are X and ID.

Expression is sum(Amount)

Hope I didn't miss anything essential.

Re: Top N Customers - Number Series with Step

Tue, 05 May 2015 17:16:25 GMT

Dear Mr. Michael,

Though I've not yet worked out your solution but seeing at your details Step-by-Step narration, it's really amazed me and can't stop leaving a note for you first. I must appreciate it and a big THANK YOU to you!

I hope this will work and Thanks again for your help.

- Sajjad.