Display % and value with dual

[sergio0592]

Hi all,

I saw a post two or three weeks ago with question about how to display value and % on data point bar chart. Sunny solved the problem with using dual function.

I have made a dummy using dual (see below). So i know the dual() function, but in this case, i can't understand how dual () works??

Is there experts can explain how it works?

Regards

[vishsaggi · Accepted solution]

If i am not wrong Dual takes Text and a Number. Like Dual(Text, Number) So internally while calculating expressions the Number value will get calculated and plot the Graph accordingly, and the text part plays as a Data value points, in this case your data values on those bars. So the number you see on your bar like 543 & -19.9% they are in text format. Correct me?

[Clever_Anjos]

Dual() function return a mixed value with

• a string representation (what you 'see')
• an intrisic value (the 'actual' value)

Example:

Dual('True',1) and Dual('False',0) represent boolean values, you 'see' true/false but you can Sum() and find out how many true values you have

[maxgro]

more info on dual here

Data Types in QlikView

[sergio0592]

Thanks Vishwarath, it's very clear now.