topic Adding text to a value expression in QlikView

Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 10:53:35 GMT

I have the following gauge in my dashboard:

I need to add text 'from last month' after the -23.1% in the chart and i tried the following expression:

=(Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx)) - 1) & 'from last month'

This is not working as the expression is wrong. Please assist with the right expression.

Regards.

Re: Adding text to a value expression

sunny_talwar — Thu, 10 Dec 2015 10:58:32 GMT

May be leave the expression as is and add Text in chart as this new expression above. So essentially this is what I mean

Expression: =(Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx)) - 1)

Text in Chart (on presentation tab)

=(Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx)) - 1) & 'from last month'

and then you can move text in chart by pressing (Ctrl + Shift) and place it at the same spot you have your current number and hide the value on data point for the expression.

Or try this as your expression without doing any of the things I mentioned above.

Dual((Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx)) - 1) & 'from last month', (Sum({$<$(vSetMTD)>} (Rx))/Sum({$<$(vSetPreviousMonth)>} (Rx)) - 1))

Re: Adding text to a value expression

vikasmahajan — Thu, 10 Dec 2015 10:58:39 GMT

Right Click Chart Properties - > Text in Chart Option -> Type From Last Month using shift + ctrl move this to desired place

HTH

Vikas

Re: Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 11:04:37 GMT

If it is fixed, then put a Text box with your required string on top just besides your expression value and set text box background transparency to 100%

Re: Adding text to a value expression

tamilarasu — Thu, 10 Dec 2015 11:09:17 GMT

Hi Christopher,

Try your above expression like below,

Re: Adding text to a value expression

Thu, 10 Dec 2015 11:41:12 GMT

hey christopher ,

you can add a text object which will be visible on conditional.ie. it will be visible when -21.3 will be the value when your gauge will have

or you can go to presentation tab in that go to text in chart then select add. then add expression this way if((your expression which you added in gauge expression tab)>-23,'from last month'&(your expression)&'%')

Re: Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 11:51:10 GMT

Thanks Sunny, using the first option how do i hide the expression value?

Re: Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 11:51:49 GMT

Thanks Vikas

Re: Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 11:52:21 GMT

Thanks Balraj

Re: Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 11:52:46 GMT

Thanks Tamil

Re: Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 11:54:21 GMT

have you got the answer?

If yes, then close this thread by selecting the right answer

Re: Adding text to a value expression

sunny_talwar — Thu, 10 Dec 2015 12:22:55 GMT

Were you able to find it? I was not able to locate it. Please share if you did.

Thanks,

Sunny

Re: Adding text to a value expression

Anonymous — Thu, 10 Dec 2015 14:31:57 GMT

No Sunny, i did not managed to find it.

Re: Adding text to a value expression

sunny_talwar — Thu, 10 Dec 2015 14:33:17 GMT

Can you share a sample since I am not able to find a quick example to replicate the issue and help you out.