Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Rank on Dimension

Can we get the ranks/index based on dimension similar to serial number.

For Egs. for the list of below countries, I want rank without considering any expression or measures.

Rank     Country         

1               Australia

2               India

3               UK

4               US

I need to give alternate colors based on row banding in a table chart. From the above Australia row in blue, India row in White, UK in blue, US in white and it goes on.

I have dynamic products for each country and sales for each products. I am able to achieve the rowbanding by giving background color to the expressions(hardcoded).

But when the number of products vary for each country the color doesnot get aligned.

If I can get the rank for each country, this will help. The countries are displayed in Alphabetical order. Hence sorting cannot be done based on expressions.

4 Replies
Partner - Contributor III
Partner - Contributor III

if i am not wrong you want below table format:


then do following process:

  • right click on table select - properties
  • select style
  • choose table -current style
  • and format table style using custom format cell.
Contributor III
Contributor III

Thanks Supriya for the response.

I am not able to view the format in the Style tab.

Am I missing something? or is it related to version.

I am using version 12.2

Export-Chart Properties.PNG

Partner - Contributor III
Partner - Contributor III

you are on right path - follow the steps:



select Design Grid . I have mark in red


after design grid - right click on table -select Custom Format cell



Contributor III
Contributor III

Thanks Supriya.

I tried the above. But the color applies for the whole dimension. In my case it should be alternate dimension as below.


if Australia has only 4 products, only 4 rows should be blue and if france has 10 product 10 rows for France should be white color background. The number of Products may vary based on countries. I have hardcoded based on odd, even to achieve this. If I get Rank for each country it will be fixed.