topic Re: Calculated Field in Water Cooler https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523673#M1933 <HTML><HEAD></HEAD><BODY><P>Can you attach the sample</P></BODY></HTML> Wed, 04 Dec 2013 04:35:04 GMT 2013-12-04T04:35:04Z Calculated Field https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523672#M1932 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to create a calculated field [Count] in a pivot table depending on the value or the backgroundcolor of a numeric field.</P><P></P><P>Thanks in advance</P><P></P><P>Marc</P><P><BR /> </P></BODY></HTML> Wed, 04 Dec 2013 04:28:33 GMT https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523672#M1932 2013-12-04T04:28:33Z Re: Calculated Field https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523673#M1933 <HTML><HEAD></HEAD><BODY><P>Can you attach the sample</P></BODY></HTML> Wed, 04 Dec 2013 04:35:04 GMT https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523673#M1933 2013-12-04T04:35:04Z Re: Calculated Field https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523674#M1934 <HTML><HEAD></HEAD><BODY><P>Hi.. Try This hope it will help</P><P><IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/49928_Untitled.png" style="width: 620px; height: 799px;" /></P></BODY></HTML> Wed, 04 Dec 2013 04:41:24 GMT https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523674#M1934 2013-12-04T04:41:24Z Re: Calculated Field https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523675#M1935 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I think you can use the set analysis for the value</P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Prog Amount]</SPAN><SPAN style="font-size: 8pt;">={'&gt;200'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Prog Amount]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">thanks and regards</SPAN></P><P><SPAN style="font-size: 8pt;">Padma</SPAN></P><P></P><P> </P><P></P></BODY></HTML> Sat, 02 Aug 2014 11:44:17 GMT https://community.qlik.com/t5/Water-Cooler/Calculated-Field/m-p/523675#M1935 qlikoqlik 2014-08-02T11:44:17Z