Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohamedafzal
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
supriya10
Partner - Contributor III
Partner - Contributor III

if i am not wrong you want below table format:

Capture.PNG

then do following process:

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

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

supriya10
Partner - Contributor III
Partner - Contributor III

you are on right path - follow the steps:

Capture1.PNG

Capture2.PNG

select Design Grid . I have mark in red

Capture3.PNG

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

Capture4.PNG

Capture5.png

mohamedafzal
Contributor III
Contributor III
Author

Thanks Supriya.

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

RowBanding.png

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.