topic Re: straight table in QlikView

straight table

Wed, 30 Apr 2014 09:58:04 GMT

can we foramat the straight table as below

Thanks@Regards

Panireddy

Re: straight table

chiru_thota — Wed, 30 Apr 2014 17:23:02 GMT

you can .

Have you tried View --> Design Grid.

If it is dynamic data uses expression/dimension background color property to write formula with RGB you need

Re: straight table

Gysbert_Wassenaar — Wed, 30 Apr 2014 17:27:18 GMT

Yes. Click on the + in front of the dimension on the Dimensions tab of the properties window of the chart. Next select Background Color and click the Edit button. Enter an expression to calculate the color. Something like =if(sum(Value)>=0,color(1), color(2)). For the color of the expression column you do pretty much the same thing on the Expressions tab.

Re: straight table

maxgro — Wed, 30 Apr 2014 17:31:15 GMT

you can set backgroun color of dimensions and expressions

=if(mod(rowno(total),3)=1, red(), green())

Re: straight table

Thu, 01 May 2014 18:24:39 GMT

Thank you

Re: straight table

maxgro — Thu, 01 May 2014 19:05:10 GMT

If you get the answer, please close this discussion by giving Correct and Helpful answers to the posts which are useful for you. It helps others in finding answers for similar scenarios.

Re: straight table

Joseph_Musekura — Thu, 01 May 2014 19:22:47 GMT

Massimo formula will make it. I tested it and it works

/jo