Color for expression

smilingjohn — Fri, 17 Jun 2022 06:29:48 GMT

Hi All,

I have a requirement to color code one of the column by using calculated dimension.

I use this below simple calculated dimension which works perfectly fine .

If( Category=SubCategory,'G','R') This simple works for me .. But I have to use this with one of the complex expression which is below ... How can I achieve the above expression in below mentioned expression

=Aggr(count(Distinct {<Status-={'Progress','On Road','1Phase'},
Demand={'VeryHigh','Popular'}>}if(Order_Date<AcceptDate and (isnull(CLOSE_DATE) or CLOSE_DATE>=AcceptDate and (PRODUCT=(Product_Sub)or PRODUCT=('null'))),ID))
+
count(Distinct{<Status-={'Progress','On Road','1Phase'},
Demand={'VeryHigh','Popular'}>}
if(Order_Date>AcceptDate and (PRODUCT=(Product_Sub)or PRODUCT=('null')),ID)),Area,Caps,[Sub-Caps],AcceptDate)

Can someone please help me with this

Thanks

John

Re: Color for expression

smilingjohn — Fri, 17 Jun 2022 15:35:26 GMT

Hi Expertise

Any help on my above post .I tried everything that I could but it's not working for me ...

Thanks in advance

John

Re: Color for expression

smilingjohn — Tue, 21 Jun 2022 18:19:16 GMT

Hi All,

Tried with all the possibilities but I am. It able to get this .hoping any advice and help

Thanks

topic Color for expression in QlikView

Color for expression

Re: Color for expression

Re: Color for expression