topic Text + expression in button in QlikView

Text + expression in button

Mon, 16 Sep 2013 11:30:32 GMT

I have created a button that links to a sheet in my QV with some text.

After this text i want to have the summary of an expression shown.

In text field for the button i can put my expression =sum (if ([Level 1 Tryck]='Line_3612', P2_tryck='x'or P2_tryck='X')*-1) and this is ok but i also want the text BD 3612 to show in the button.

Is it possible to mix text with an expression so they are both visible on the same button?

Best regards

/Mats

Re: Text + expression in button

tresB — Mon, 16 Sep 2013 11:33:18 GMT

Try like:

='Your text' & expression

Note: '&' is used to concatenate strings

Re: Text + expression in button

Mon, 16 Sep 2013 11:33:32 GMT

Yeah you can do that following the folliwing format: '='your text' & function.

='sales are ' & sum(sales)

Re: Text + expression in button

Mon, 16 Sep 2013 11:37:05 GMT

'BD 3612' & sum (if ([Level 1 Tryck]='Line_3612', P2_tryck='x'or P2_tryck='X')*-1)

The & is used for string concatenation