Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Table - show condition

Hi,

I have made this table:

CompanyRankGross Profit
A1100$
B298$
C393$
D490$
E587$
F684$
G782$
H877$

And a filter called "ChosenCompany".

I would like to make a condition, thus the table are only showing:

- the three companies above the chosen company based on rank

- the three companies below the chosen company based on rank

- and the chosen company

Does anyone have an idea how to do this?

22 Replies
Highlighted
Partner
Partner

Still not working. Here is what I get:

Table.PNG

The company I selected was 'Mercedes-Benz Danmark A/S, which mean the table should only give me other car companies.

I think it's because I need to relate to my variable 'vChosenCompany' in the expression. What do you think about that?

Partner
Partner

Have no idea how ur data is constructed, but this works for me ; I'll attach the test application for u so that u can test it and try to adjust it :

Highlighted
Master II
Master II

Thanks a lot for your explanation Learned something new

Best Regards,
KC