topic Re: Display % and value with dual in QlikView

Display % and value with dual

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Display % and value with dual

vishsaggi — Fri, 15 Sep 2017 19:10:24 GMT

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?

Re: Display % and value with dual

Clever_Anjos — Fri, 15 Sep 2017 19:25:42 GMT

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

Re: Display % and value with dual

maxgro — Fri, 15 Sep 2017 20:25:00 GMT

more info on dual here

Data Types in QlikView

Re: Display % and value with dual

sergio0592 — Fri, 15 Sep 2017 22:17:40 GMT

Thanks Vishwarath, it's very clear now.