https://community.qlik.com/t5/App-Development/Changing-the-text-colour-for-Row-cells-values-in-vizlib-pivot/m-p/2434096#M96875 <P>Hello&nbsp;@all</P> <P>I am currently using vizlib pivot table&nbsp; with dimensions and measures. i have Prime choice field where i need to change the text colour of the values based on some logics how ever i don't find any custom expression option to write an expression in the vizlib pivot table i tried to write the condition in Dynamic style add condition.</P> <P>I have Added the Prime choice field and in the List of seperated values</P> <P>I used the condition like this&nbsp;</P> <P>concat(aggr(if((vACtype)='Yes',if(Left(INDUS_PRIME_CHOICE,4)='A318',INDUS_PRIME_CHOICE),INDUS_PRIME_CHOICE),','))&nbsp; and assigned the font colour as pink but this expression is not working please help me with this expression</P> <P>&nbsp;</P> <P>Note: my logic is if Ac type is yes and the prime choice is 318 then the font colour should be pink.</P> Fri, 15 Nov 2024 21:01:20 GMT N_avya1 2024-11-15T21:01:20Z https://community.qlik.com/t5/App-Development/Changing-the-text-colour-for-Row-cells-values-in-vizlib-pivot/m-p/2434096#M96875 <P>Hello&nbsp;@all</P> <P>I am currently using vizlib pivot table&nbsp; with dimensions and measures. i have Prime choice field where i need to change the text colour of the values based on some logics how ever i don't find any custom expression option to write an expression in the vizlib pivot table i tried to write the condition in Dynamic style add condition.</P> <P>I have Added the Prime choice field and in the List of seperated values</P> <P>I used the condition like this&nbsp;</P> <P>concat(aggr(if((vACtype)='Yes',if(Left(INDUS_PRIME_CHOICE,4)='A318',INDUS_PRIME_CHOICE),INDUS_PRIME_CHOICE),','))&nbsp; and assigned the font colour as pink but this expression is not working please help me with this expression</P> <P>&nbsp;</P> <P>Note: my logic is if Ac type is yes and the prime choice is 318 then the font colour should be pink.</P> Fri, 15 Nov 2024 21:01:20 GMT https://community.qlik.com/t5/App-Development/Changing-the-text-colour-for-Row-cells-values-in-vizlib-pivot/m-p/2434096#M96875 N_avya1 2024-11-15T21:01:20Z