Button

[#1]

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

[datanibbler]

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

[manojkulkarni]

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'

[#4]

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.

[jsingh71]

Hi,

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

[#6]

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')

[datanibbler]

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).

[manojkulkarni]

it should be..

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

[#9]

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?

[manojkulkarni]

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

set vLaneSales = selected value from slider.