topic Re: reg-visual cubes in QlikView

reg-visual cubes

Wed, 21 May 2014 06:01:33 GMT

HI Team,

1. i have 500 records in my table and i want to get if 1-50 records should get yellow color,50-100=orange,100-150=blue for this we can write condition or normally we can do like if records>50 yellow

can anyone say

Re: reg-visual cubes

tresB — Wed, 21 May 2014 06:04:49 GMT

If it's a straight table, try expression like: If(RowNo(Total)>50, yellow(), ....)

Re: reg-visual cubes

Wed, 21 May 2014 06:10:47 GMT

thanx

Re: reg-visual cubes

Wed, 21 May 2014 06:12:12 GMT

and can u say one thing if i have 100 records and i want to display top 5 records and low 5 records

Re: reg-visual cubes

cfz — Wed, 21 May 2014 06:22:18 GMT

Hi,

You can write an expression for doing this in the background color under the dimension like in the attached example .

I hope it helps

Carlos

Re: reg-visual cubes

tresB — Wed, 21 May 2014 06:26:41 GMT

reg-var

Re: reg-visual cubes

preminqlik — Wed, 21 May 2014 06:27:06 GMT

sum({{<Dimension={'=rank(sum(sales))<6'}>}sales) top 5

sum({{<Dimension={'=rank(-sum(sales))<6'}>}sales) bottom 5