topic Re: Show customers based on a button in QlikView

Show customers based on a button

Tue, 23 Apr 2013 13:04:19 GMT

Hello

If i have a listbox with customers from A to Z - But i have sooooo many i wanna split them up.

I wanna split them up by a button

My button should be named A to F and when i press that button, i should only be able to see customers from A to F in a listbox...

How do i do that???

I created a listbox called Customers

And a button called A to F

In my button i created an action called select in field (field: Customers, Search string: if(DimCustomers < 'G', DimCustomers, '')

But that does not seem to work?

Re: Show customers based on a button

Tue, 23 Apr 2013 13:07:01 GMT

define variable for your range of name then take

button-->

action-->

setvariable-->

variablename= var

Re: Show customers based on a button

Tue, 23 Apr 2013 13:16:36 GMT

That does not work??

what should value be? And i guess my variable should not be vCustomers = if(DimCustomers < 'G', DimCustomers, '')

buy something else

vCustomers = DimCustomers>='G' ??

Re: Show customers based on a button

Anonymous — Tue, 23 Apr 2013 13:23:48 GMT

Hi,

You can use function

ORD(custumer)

which returns an integer that is the ASCII number of the first letter of your filed "custumer"

If you want to cut with "F", then the ASCII number is 70. You can use a button with condition on ASCII number.

In your script you can add the table:

CustumerLetter:

LOAD

custumer,

if(ORD(custumer)<=70,'A to F','G to Z') as CustumerLetter

RESIDENT

YourTableName;

Then your don't even need button, your selection list on CustumerLetter is enough

If you want more help, join your qvw

Re: Show customers based on a button

Tue, 23 Apr 2013 13:39:33 GMT

Ive just attached my document. Can you have a look=? I dont wont to cut anything away in my model.

I just want Buttons to be like A to F and G to L for instance

Which when you hit one of the buttons, you are only able to see A to F Customers in a listbox..

Thanks in advanced!

Re: Show customers based on a button

Anonymous — Tue, 23 Apr 2013 13:44:45 GMT

Your document was not joined to your message.

But you can use this method:

CustumerLetter:

LOAD

custumer,

if(ORD(custumer)<=70,'A to F',if(ORD(custumer)<=76,'G to L','M to Z')) as CustumerLetter

RESIDENT

YourTableName;

Then your don't even need button, your selection list on CustumerLetter is enough

If you want more help, join your qvw

Re: Show customers based on a button

Tue, 23 Apr 2013 13:55:20 GMT

YEs it is in the top, to the subject.

How do you know which ord number the specific letters got?

But, i want a button !! I dont want to cut it out by scripting.. I can easily do that by other methods.

Re: Show customers based on a button

Tue, 23 Apr 2013 14:09:06 GMT

How come it does not work with a simple variable?

if i got variable vCustomerAtoF = if(DimCustomers < 'F', DimCustomer,'')

If i type the expression in my listbox then i will get all customers up to F

However, do i insert it as a variable, nothing happens? But its the same basically?

Re: Show customers based on a button

alexpanjhc — Tue, 23 Apr 2013 16:10:10 GMT

the attached should work as you asked.

Re: Show customers based on a button

kuba_michalik — Tue, 23 Apr 2013 16:30:34 GMT

Too many equal signs.

Your variable is: =if(DimCustomers < 'F', DimCustomer,'')

If you put $(vCustomerAtoF) as expression in ListBox, QlikView will always stick '=' in front of it automatically, and the formula will expand to ==if(DimCustomers < 'F', DimCustomer,'') wihich is invalid. Remove equal sign from variable contents and it should work. Also, I suggest using Null() instead of '', or you will get a clickable blank value associated to all clients over F in your listbox.

Re: Show customers based on a button

Tue, 23 Apr 2013 18:17:49 GMT

brilliant, can you maybe explain what the expressions do?

what does if(cid,1,0,1) do??

and what does if(dimcustomers,1)>'m',dimcustomers do??

Re: Show customers based on a button

Tue, 23 Apr 2013 18:28:01 GMT

if i use a variable and do like you said. It will only be show customers from A to M, but when i try to hit the button again, to see the rest, it disspear, like its hidden

Re: Show customers based on a button

Tue, 23 Apr 2013 18:28:45 GMT

How come my table is hidden when trying to make it a variable, i can repost the document, so you can see what i mean?

and what if i want to make a button for both A to M and a button for N to Z

*****New document uploaded with new example

Re: Show customers based on a button

alexpanjhc — Tue, 23 Apr 2013 18:36:36 GMT

if(cid,1,0,1) is to make the cid change every time a click is happen.

left

(DimPotentialCustomers.CustomerID ,1)>'m', is to make sure all the customer's first letter is from A-M.

if you have 2 buttons that's fine too, you do need to 2 variable for each botton and then in the action set them to 1.(you do not need if(cid,1,0,1) instead you juts put 1 there)

Re: Show customers based on a button

Tue, 23 Apr 2013 18:40:19 GMT

how did you make my listbox able to take from N to last when hitting button?

Which expressions says that ?

Is tgat because of the 1 in left(dimpotentialcustomers,1) > 'm' ?

So when CID is 1 its bigger than M ??

Re: Show customers based on a button

alexpanjhc — Tue, 23 Apr 2013 18:47:12 GMT

there are actually 2 list boxs. one shows from A-M the other shows from N-Z

When the button was hit, one is hidden.

in the layout of the listbox, there is a show condition look at there.

left function returns the number of the charactor of the string, in this case is the first charactor of the customerID.

CID is only a variable to define the show condition.

Re: Show customers based on a button

Tue, 23 Apr 2013 18:50:26 GMT

AHHH so you placed two listboxes ontop of each other!! FANCY!! and tricky! Then it works... thanks