Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Dual functiononly bring back value

Can't get the following dual statement to work in a pie graph. All it does is give the number but won't show the Key|State field. I have the Default Expression checked for the number format.

Dual(Key|State&chr(10)&[Controllable Mod]/([Projected Mod]-[Minumum Mod]) ,
[Controllable Mod]/([Projected Mod]-[Minumum Mod]
))

Labels (1)
4 Replies
sunny_talwar
MVP
MVP

On the chart itself you want to see Key|State instead of the number?

sunny_talwar
MVP
MVP

Seems to be working here:

Capture.PNG

zagzebski
Creator
Creator
Author

Thanks. I don't get it - mine expression is dong just like yours only a bit more complicated. Its seems "buggy" as I got it to work on one pie chart but now can't get it to work on another.

sunny_talwar
MVP
MVP

May be try re-creating the chart from scratch. Not sure what might be wrong