topic Re: Dual functiononly bring back value in QlikView https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132148#M372095 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sun, 24 Jul 2016 00:16:52 GMT zagzebski 2016-07-24T00:16:52Z Dual functiononly bring back value https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132145#M372092 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;">Dual</SPAN><SPAN style="font-size: 12pt;">(Key|State&amp;<SPAN style="color: #0000ff;">chr</SPAN>(10)&amp;<SPAN style="color: #800000;">[Controllable Mod]</SPAN>/(<SPAN style="color: #800000;">[Projected Mod]</SPAN>-<SPAN style="color: #800000;">[Minumum Mod]</SPAN>) ,<BR /> <SPAN style="color: #800000;">[Controllable Mod]</SPAN>/(<SPAN style="color: #800000;">[Projected Mod]</SPAN>-<SPAN style="color: #800000;">[Minumum Mod]</SPAN></SPAN><SPAN><SPAN style="font-size: 12pt;">))</SPAN><BR /> </SPAN></P></BODY></HTML> Sat, 23 Jul 2016 22:52:02 GMT https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132145#M372092 zagzebski 2016-07-23T22:52:02Z Re: Dual functiononly bring back value https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132146#M372093 <HTML><HEAD></HEAD><BODY><P>On the chart itself you want to see Key|State instead of the number?</P></BODY></HTML> Sat, 23 Jul 2016 22:53:13 GMT https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132146#M372093 sunny_talwar 2016-07-23T22:53:13Z Re: Dual functiononly bring back value https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132147#M372094 <HTML><HEAD></HEAD><BODY><P>Seems to be working here:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132288_Capture.PNG" style="height: 188px; width: 620px;" /></P></BODY></HTML> Sat, 23 Jul 2016 22:55:32 GMT https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132147#M372094 sunny_talwar 2016-07-23T22:55:32Z Re: Dual functiononly bring back value https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132148#M372095 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sun, 24 Jul 2016 00:16:52 GMT https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132148#M372095 zagzebski 2016-07-24T00:16:52Z Re: Dual functiononly bring back value https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132149#M372096 <HTML><HEAD></HEAD><BODY><P>May be try re-creating the chart from scratch. Not sure what might be wrong <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 24 Jul 2016 00:30:23 GMT https://community.qlik.com/t5/QlikView/Dual-functiononly-bring-back-value/m-p/1132149#M372096 sunny_talwar 2016-07-24T00:30:23Z