topic Re: Format Pivot Data in QlikView

Format Pivot Data

upaliwije — Thu, 16 Feb 2017 08:10:28 GMT

I have following pivot table in my QV document

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)

vinieme12 — Thu, 16 Feb 2017 08:36:12 GMT

=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()) )

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

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

priyasawant — Thu, 16 Feb 2017 08:50:12 GMT

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

upaliwije — Thu, 16 Feb 2017 09:26:10 GMT

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 — Thu, 16 Feb 2017 09:39:13 GMT

Check the attached

antoniotiman — Thu, 16 Feb 2017 09:50:00 GMT

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 — Thu, 16 Feb 2017 09:59:34 GMT

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