topic Re: negative value in bracket in QlikView https://community.qlik.com/t5/QlikView/negative-value-in-bracket/m-p/117241#M760995 <HTML><HEAD></HEAD><BODY><P>Hi Sony,</P><P></P><P>You can do it two ways,</P><P><IMG __jive_id="210206" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210206_Capture.PNG" style="height: 187px; width: 620px;" /></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Or</STRONG></P><P><IMG __jive_id="210207" alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/210207_Capture1.PNG" style="height: 195px; width: 620px;" /></P><P></P><P>Output:</P><P><IMG alt="Capture.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/210208_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 08 Aug 2018 07:29:47 GMT tamilarasu 2018-08-08T07:29:47Z negative value in bracket https://community.qlik.com/t5/QlikView/negative-value-in-bracket/m-p/117240#M760994 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i have a sample data like below</P><P></P><P><SPAN style="font-size: 13.3333px;">Tab:</SPAN></P><P><SPAN style="font-size: 13.3333px;">Load * Inline [</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Name,Produt,sales</SPAN></P><P><SPAN style="font-size: 13.3333px;">raju,A,100</SPAN></P><P><SPAN style="font-size: 13.3333px;">siva,B,200</SPAN></P><P><SPAN style="font-size: 13.3333px;">yannie,C,-300</SPAN></P><P><SPAN style="font-size: 13.3333px;">anu,D,-600</SPAN></P><P><SPAN style="font-size: 13.3333px;">venkat,E,500]</SPAN></P><P><SPAN style="font-size: 13.3333px;">;</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">so i want in front end&nbsp;&nbsp; if the value is in negative&nbsp; it should show in ()&nbsp; if value is possitive&nbsp; normal number it can show&nbsp;&nbsp; [Stright table]</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">example:&nbsp;&nbsp; -300&nbsp;&nbsp; means&nbsp;&nbsp; (300)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks</SPAN></P><P><SPAN style="font-size: 13.3333px;">Sony<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/negative-value-in-bracket/m-p/117240#M760994 soniasweety 2020-11-25T16:16:04Z Re: negative value in bracket https://community.qlik.com/t5/QlikView/negative-value-in-bracket/m-p/117241#M760995 <HTML><HEAD></HEAD><BODY><P>Hi Sony,</P><P></P><P>You can do it two ways,</P><P><IMG __jive_id="210206" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210206_Capture.PNG" style="height: 187px; width: 620px;" /></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Or</STRONG></P><P><IMG __jive_id="210207" alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/210207_Capture1.PNG" style="height: 195px; width: 620px;" /></P><P></P><P>Output:</P><P><IMG alt="Capture.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/210208_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 08 Aug 2018 07:29:47 GMT https://community.qlik.com/t5/QlikView/negative-value-in-bracket/m-p/117241#M760995 tamilarasu 2018-08-08T07:29:47Z