Discussion Board for collaboration related to QlikView App Development.
I have employee table having employee information.I want to select two employee at a time in straight table.
if i select two records and if i want salary of second selected employee how can i get that in Qlikview?
Message was edited by: Gaurav Wani
I have added supporting files.
I want to select empid 1 and 4 and i want to view or compare their salary side by side then how can i achieve this?
could you post some sample data or describe your table a bit more? (dimensions, expressions...)
You would have to use Set Analysis. For example if your data is this ...
Load * inline [EmpId, Salary1, 30002, 40004, 5000];
.. then you can get the min and max salaries selected using these ...
I have attached supported documents
If it is inside the same table and you have it in column 1 ordered by salary descending, then you go like:
TOP (total COLUMN(1),2) .
Outside the table with a macro. You can get any value, any cell from any table with a macro.
Try to use function rank.