topic Button in QlikView

Button

Mon, 17 Mar 2014 08:34:29 GMT

Hi all,

I just finished building a table containing all sort of data.

The tab also contains a max button that will show me every customer. Next to this button I got a slider that will show me a number of customers.

Now I was wondering if it is possible that when I select this max button my caption will say:' All customers' and when I don't have this button selected it says 'Top ...'

I was already thinking about using 2 variables but maybe there is a easyier way of solving this problem?

kind regards

Re: Button

datanibbler — Mon, 17 Mar 2014 08:44:21 GMT

Hi Vincent,

sure you can do that.

What exactly does your button do? I guess it controls some variable?

=> If so, just make the caption_bar of your chart dependent on the same variable.

HTH

Best regards,

DataNibbler

Re: Button

manojkulkarni — Mon, 17 Mar 2014 08:48:03 GMT

You can use a single variable to show the title of chart.

vCountofCustomer = 0, when button is clicked

vCountofCustomer = selected value from slider.

If vCountofCustomer =0, 'All Customer', ;Top '& vCountofCustomer&' customer'

Re: Button

Mon, 17 Mar 2014 08:48:31 GMT

Hi my button got a variable and the value counts the number of customers.

Now my caption does contain the variable so it will show me how many customers I got selected on the slider. However I want it to have 2 options. The one I use the slider it gives me a number (how many selected) and the second it will will say I got the total customers when the max button is used.

Re: Button

jsingh71 — Mon, 17 Mar 2014 08:48:50 GMT

Hi,

You will do this...share some information or screenshot ,where you want to show the caption.

Re: Button

Mon, 17 Mar 2014 08:59:44 GMT

This is now in my caption: 'Top ' & vLaneSales& ' Lane Sales(in K)'

This how I now got it but it doesnt show me anything

=if(vLaneSales= 0 & ' All lane Sales(in K)', 'Top ' & vLaneSales& 'Lane Sales')

Re: Button

datanibbler — Mon, 17 Mar 2014 09:04:13 GMT

Hi Vincent,

the IF_construction is wrong. Look at that closely. You're close. (Hint: If you start typing as far as '= IF(' in the editor, QlikView will show you exactly what parameters and stuff it expects).

Re: Button

manojkulkarni — Mon, 17 Mar 2014 09:07:18 GMT

it should be..

if(vLaneSales= 0 , ' All lane Sales(in K)', 'Top ' & vLaneSales& 'Lane Sales')

Re: Button

Mon, 17 Mar 2014 09:13:51 GMT

if I use your formula it will only use the second part of the the expression 'Top ' & vLaneSales& 'Lane Sales')

do I need to edit something in the button?

Re: Button

manojkulkarni — Mon, 17 Mar 2014 09:15:23 GMT

on Button Action, you need to set vLaneSales=0 & on change of slider

set vLaneSales = selected value from slider.

Re: Button

Mon, 17 Mar 2014 09:27:33 GMT

that needs to be in button->actions->the value or variable?

Re: Button

manojkulkarni — Mon, 17 Mar 2014 09:36:45 GMT

Button-Actions-Set Variable-> Variable = vLanesales

Value= 0

Re: Button

Mon, 17 Mar 2014 09:41:20 GMT

My button won't show max then if I just put value =0

Re: Button

manojkulkarni — Mon, 17 Mar 2014 09:44:49 GMT

pls can you share your application, will check it

Re: Button

Mon, 17 Mar 2014 09:53:25 GMT

is there a guide or something how to make one?

Or can I just make a new qv file just containing the formula's?