topic Re: Calculated dimension total colour in QlikView

Calculated dimension total colour

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have used an calculated dimension but when i gave background color condition it is showing nothing total but it is colored.

Here i need to remove color to the total.

Calculated dimension :

=aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales))

/(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)

+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),' #,##0.0%'),Loc,APA0TX,NEW)

Thanks..

Re: Calculated dimension total colour

nareshthavidishetty — Thu, 02 Feb 2017 19:45:21 GMT

Hi,

Below is the clor condition used.

=if((aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)) /(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales) +sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),' #,##0.0%'),Loc,APA0TX,NEW)) *100 >=70

and (aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)) /(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales) +sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),' #,##0.0%'),Loc,APA0TX,NEW)*100) <90 ,RGB(252,219,8) ,

if((aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)) /(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales) +sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),' #,##0.0%'),Loc,APA0TX,NEW)*100)>=90 ,rgb(0,238,0),

If(isnull(aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)) /(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales) +sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),' #,##0.0%'),Loc,APA0TX,NEW)) <= 0 , rgb(255,69,0)))))

Thanks..

Re: Calculated dimension total colour

vinieme12 — Thu, 02 Feb 2017 20:00:49 GMT

Try below

If ( not rowno(total) =0 ,

)

Re: Calculated dimension total colour

nareshthavidishetty — Fri, 03 Feb 2017 02:10:52 GMT

Hi,

I have used the expression but It doesn't change the output.

Thanks..

Re: Calculated dimension total colour

Anil_Babu_Samineni — Fri, 03 Feb 2017 02:26:12 GMT

This kind of expression you want to do in BG. You should share the application then only we can figure out (In fact)