Discussion board where members can get started with Qlik Sense.
I have made this table:
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?
Still not working. Here is what I get:
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?
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 :
Thanks a lot for your explanation Learned something new