Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

azimabadi
Contributor II

$ that i want not to work

Hi All,

I have a variable, let's say myVar. I have a straight table that i want to show $(myVar) as the lable of an expression. But i cant write any statement that show $(myVar) as the lable of column.

I will apreciate any idea.

Best Regards

Peyman

Tags (1)
1 Solution

Accepted Solutions
azimabadi
Contributor II

Re: $ that i want not to work

I have solved the problem with this statement:

= '$' & chr(12) & '(myVar)'

charachter 12 is the form feed code and has no visual effect.

Best Regards

Peyman

10 Replies
MVP
MVP

$ that i want not to work

Very interesting,

I assumed that something like

=chr(36) &'(myVar)'

or

=replace('@(myVar)','@','$')

should work, but failed for the label. There must be something special with the label evaluation (like a multiple evaluation), since above expressions for the label as well the original $(myVar) works for the title bar.

Well, I am also stucked.

Maybe one workaround: Add a space between $ and (myVar)

$ (myVar)

as label.

msheraton
Contributor III

$ that i want not to work

So you want the literal text to be '$(myVar)' for the label header?

Would be usefull to know what you're trying to achieve by doing this.

You can put the text '$(myVar)' inside the variable myVar to do this, don't think this is what you want though...

Mark

azimabadi
Contributor II

$ that i want not to work

Hi  swuehl,

thank you for answer. i think a space between $ and ( is what i can use if i find no other solution. Please let me know if you have faound any thin else.

Best Regards

Peyman

azimabadi
Contributor II

$ that i want not to work

Hi Mesheraton,

Thanks for answer. but i have another value in this variable that i need to keep it.

Best Regards

Peyman

azimabadi
Contributor II

Re: $ that i want not to work

I have solved the problem with this statement:

= '$' & chr(12) & '(myVar)'

charachter 12 is the form feed code and has no visual effect.

Best Regards

Peyman

Not applicable

$ that i want not to work

Hi,

i've never faced a thing like that.

Could you please tell us what you expect to see on the label? I mean, you can write it down as example.

Thank you

Giampiero

MVP
MVP

Re: $ that i want not to work

Good idea!

But chr(12) is giving a symbol at my side (looks like the female sign), I needed to use chr(10) or chr(13) (but these may interfere with wrap header setting) and ended up with chr(9).

Regards,

Stefan

azimabadi
Contributor II

Re: $ that i want not to work

Hi giampiero,

here in our firm, everyday i face problems like no others .

I think it's the same for most of QV developers.

You can check my example file that is attached.

Best Regards

Peyman

azimabadi
Contributor II

Re: $ that i want not to work

@Swuehi : i think every control charachter can be used. in my PC 9, 11, 12 works good!

Best Regards

Peyman

Community Browser