Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Format Pivot Data

I have following pivot table in my QV document

YEARAB
201444,6891,859,582
201543,2811,931,597
201645,7642,140,009
201745,3992,482,854

I want to highlight Max amount and Min amount in my pivot table (both font and Back ground of Cell) like given above. Pls help me

My expression is sum(amount)

1 Solution

Accepted Solutions
sunny_talwar

Check the attached

Capture.PNG

View solution in original post

6 Replies
vinieme12
Champion III
Champion III

=if(Sum(Sales) = Max(Total <YEAR,Dim2>  AGGR( Sum(Sales) ,YEAR,Dim2)) , red()

          ,if(Sum(Sales) = Min(Total <YEAR,Dim2>  AGGR( Sum(Sales) ,YEAR,Dim2)) , green()) )


or


=if(Sum(Sales) = Max( AGGR(NODISTINCT Sum(Sales) ,YEAR,Dim2)) , red()

          ,if(Sum(Sales) = Min( AGGR(NODISTINCT Sum(Sales) ,YEAR,Dim2)) , green()) )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
priyasawant
Creator II
Creator II

This can be done in Expression tab --> Background color & Text colorCapture.PNG

upaliwije
Creator II
Creator II
Author

Thanks Vineeth

I have tried your expression. but it does not work in my Qv Doc. Pls have a look at it correct me. I am attaching my doc.

sunny_talwar

Check the attached

Capture.PNG

antoniotiman
Master III
Master III

Hi,

try

If(RangeMin(Top(Column(1),1,NoOfRows()))=Column(1),Green(),
If(RangeMax(Top(Column(1),1,NoOfRows()))=Column(1),Red()))

Regards,

Antonio

sdmech81
Specialist
Specialist

Hi,

PFA fr thr application. Both text coring and background coloring is shown with example..

in expression tab u have to click on as shown bolow..

ANd I have created to variables in the appliactions..

please check thm out..

expression r like

vcol_Value=max(aggr(sum(amount),date))

vCol_Value2=min(aggr(sum(amount),date))

=IF(sum(amount)=vcol_Value,Red(),if(sum(amount)=vCol_Value2,Green()))

Hope it helps