Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Help needed with Ranking table Sales

Good Day,

A question.

We have a Sales environment where the client wants to see a ranking system.

We have the following dimensions:

1. Brand

2. Article

Measures:

1. Revenue.

 

Now the client wants the following:

A table with 5 columns.

Column 1:

The brand (easy)

Column 2:

Articles

Column 3:

The articles of this brand sorted in order of revenue/Total Revenue of this brand (%)

Column 4:

When a client is selected, the first two columns must stay the same, this column should show the same as column 2, but for this client. 

And This should also show the articles where there isn't any revenue at the moment in red. (difficult)

 

Column 5

Here the actual revenue is shown instead of a percentage.

 

This is probably a very hard thing to achieve.

But any help would be welcome.

 

I made examples and attached them in and excel file what the result could be.

 

Thanks a bunch

Dries 

Labels (3)
0 Replies