topic Re: Previous and Next button for 2 bar charts in QlikView

Previous and Next button for 2 bar charts

jim_chan — Tue, 25 Oct 2016 10:18:48 GMT

Hi guys,

just wan to know whether it is possible or not.

I have 2 bar charts to show.. side by side. i cant use the srcollling and limit to certain value shown, because if i do so, i have to scroll the left barr then scroll th right bar as well.

i am thinking, can i create Next or Previous button , and set it to show 5 data each time, previous or next. but when i click on the button, both bar charts to should be affected as well.

anyone there???

Rgds

Jim

Re: Previous and Next button for 2 bar charts

shraddha_g — Tue, 25 Oct 2016 10:26:02 GMT

use same button variable in both charts

Re: Previous and Next button for 2 bar charts

lakshmikandh — Tue, 25 Oct 2016 10:29:42 GMT

Hi, you can sort it by measure expression and set it to show top 10 fixed number and check option to show others

When you click on others then it will show next top 10 , etc .

Re: Previous and Next button for 2 bar charts

jim_chan — Tue, 25 Oct 2016 10:33:30 GMT

No.. point here is. if by doing so, 1st - of course it will show top 10, but.. when i want to look at the next 10, i will have to scroll bar chart 1 , adn then scroll bar chart 2.

client is looking for a button, where when click on Next, both chart will scroll to the Next 10.

Re: Previous and Next button for 2 bar charts

jim_chan — Tue, 25 Oct 2016 10:34:31 GMT

but how to write that variable for that button? if i want the next button to show next 5.

Re: Previous and Next button for 2 bar charts

johnw — Tue, 25 Oct 2016 17:39:11 GMT

This isn't strictly what you asked for, but I feel meets the same sort of requirement. It uses a slider on the dimension with a fixed range. So it's making actual selections rather than scrolling through the selections. But if you really don't want it making selections, but only scrolling what was selected, I'm sure that's doable too. I'm thinking about how I might approach it.

Re: Previous and Next button for 2 bar charts

johnw — Tue, 25 Oct 2016 17:56:32 GMT

Here's a possible solution that looks virtually the same as the previous, but doesn't change your actual selections. It shows 5 at a time of whatever you've actually selected.

Re: Previous and Next button for 2 bar charts

jim_chan — Wed, 26 Oct 2016 22:57:39 GMT

Hi John,

Ok. i will use the slider. i want to use the field for example "Country" in my slider.

but in order for it to work, do i need to change the "country" to number format??? I dont know how.

the DIM that you showed was in number format.

Rgds

Jim

Re: Previous and Next button for 2 bar charts

johnw — Wed, 26 Oct 2016 23:37:10 GMT

For the expression I used, yes, but the idea can be extended. There's probably a simpler approach, but...

Data:
LOAD
chr(ord('A')-1+ceil(rand()*25)) as Dim
,ceil(rand()*10) as Val1
,ceil(rand()*100) as Val2
AUTOGENERATE 100
;
Show:
LOAD recno() as Rank
AUTOGENERATE fieldvaluecount('Dim')
;

Use Rank as the slider. Use this for your charts' dimension:

=aggr(if(1 + count(total distinct Dim) - rank(Dim)<=max(Rank) and 1 + count(total distinct Dim) - rank(Dim)>=min(Rank),Dim),Dim)

Re: Previous and Next button for 2 bar charts

jim_chan — Thu, 27 Oct 2016 00:02:29 GMT

if i already have a field "Country" in my data loading.

load

Country,

recno() as Rank

Is it like this will do??

Rgds

Jim

Re: Previous and Next button for 2 bar charts

johnw — Thu, 27 Oct 2016 00:21:25 GMT

No. Depending on what you're loading from, that might or might not assign the right Rank values. But what it will definitely do is connect Country with Rank in the data model, which we need to avoid. Once you've loaded the table(s) that have Country in them, do this, mirroring what I had in the example.

Show:
LOAD recno() as Rank
AUTOGENERATE fieldvaluecount('Country')
;

Or maybe it's more clear if we do it with two variables. See attached.

Re: Previous and Next button for 2 bar charts

jim_chan — Wed, 23 Nov 2016 03:10:32 GMT

Hi, but i how can fixed the range??? is it possible to fixed the range? everytime when i use the roller on my mouse, the range will be different.

but i need to be fixed.

Re: Previous and Next button for 2 bar charts

jim_chan — Wed, 23 Nov 2016 03:11:24 GMT

what buttons do you mean?