topic Re: Custom cell formatting issue in QlikView https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000925#M340259 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data with your expected output? I am sure what you want would be possible, but I am not 100% certain what exactly you are looking to do. When you share an example, I will know what exactly you are looking for.</P></BODY></HTML> Wed, 09 Sep 2015 10:12:43 GMT sunny_talwar 2015-09-09T10:12:43Z Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000919#M340253 <HTML><HEAD></HEAD><BODY><P>I am attempting to colour different cells ( containing only text ) in my pivot table using the custom format cell option. However using the option it colours all of the cells in the particular column rather than the specific one I selected. </P><P></P><P>Any ideas ?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 09 Sep 2015 10:02:19 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000919#M340253 2015-09-09T10:02:19Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000920#M340254 <HTML><HEAD></HEAD><BODY><P>Why don't you try it with Background Color expression if you only want to color particular cells?</P></BODY></HTML> Wed, 09 Sep 2015 10:03:44 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000920#M340254 sunny_talwar 2015-09-09T10:03:44Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000921#M340255 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Yes that's what I'm doing but it ends up colouring all of the cells rather than just the selected one </SPAN></P></BODY></HTML> Wed, 09 Sep 2015 10:05:09 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000921#M340255 2015-09-09T10:05:09Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000922#M340256 <HTML><HEAD></HEAD><BODY><P>What condition (expression) are you using?</P></BODY></HTML> Wed, 09 Sep 2015 10:07:48 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000922#M340256 sunny_talwar 2015-09-09T10:07:48Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000923#M340257 <HTML><HEAD></HEAD><BODY><P>Only have the option of selecting 'current expression' or all expressions or all expressions / dimensions which is why Im guessing it's colouring all of the cells belonging to that expression. Is there a different option I should get to colour only one particular row ? Is this type of formatting perhaps only limited to certain types of charts / tables ?</P></BODY></HTML> Wed, 09 Sep 2015 10:10:29 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000923#M340257 2015-09-09T10:10:29Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000924#M340258 <HTML><HEAD></HEAD><BODY><P>what kind of values u have in cells </P><P>can u share sample ?</P></BODY></HTML> Wed, 09 Sep 2015 10:11:45 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000924#M340258 2015-09-09T10:11:45Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000925#M340259 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data with your expected output? I am sure what you want would be possible, but I am not 100% certain what exactly you are looking to do. When you share an example, I will know what exactly you are looking for.</P></BODY></HTML> Wed, 09 Sep 2015 10:12:43 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000925#M340259 sunny_talwar 2015-09-09T10:12:43Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000926#M340260 <HTML><HEAD></HEAD><BODY><P>Please find data attached ... thanks</P></BODY></HTML> Wed, 09 Sep 2015 10:26:53 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000926#M340260 2015-09-09T10:26:53Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000927#M340261 <HTML><HEAD></HEAD><BODY><P>That is how Custom Format Cell works. If you want som specific row highlighted you will have to use either expression / format options or Visual Cues tab....</P></BODY></HTML> Wed, 09 Sep 2015 11:13:35 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000927#M340261 petter 2015-09-09T11:13:35Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000928#M340262 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>U can do it in the visual cues option .</P></BODY></HTML> Wed, 09 Sep 2015 11:15:46 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000928#M340262 2015-09-09T11:15:46Z Re: Custom cell formatting issue https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000929#M340263 <HTML><HEAD></HEAD><BODY><P>you can add an expression in Background Color of all the Dimensions or Expression you want to change (color)</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98379_1.png" style="height: 148px; width: 620px;" /> </P></BODY></HTML> Wed, 09 Sep 2015 12:38:11 GMT https://community.qlik.com/t5/QlikView/Custom-cell-formatting-issue/m-p/1000929#M340263 maxgro 2015-09-09T12:38:11Z