Discussion board where members can get started with QlikView.
It's look like very simple question...
Please look at the script on the attached qvw.
In this script I has:
LOAD * INLINE [
ACT, PARAM, COEF
1, W, 3.66
1, M, 1
2, W, 2.5
2, M, 1
3, W, 3.4
3, M, 1.5
Now, I want to get a table without duplicity. In this table - for every ACT it will be only 1 row.
So, if the PARAM = 'W' the COEF falue will be under Final.WorkerCoef
AND, if the PARAM = 'M' the COEF falue will be under Final.MachineCoef
Actualy I want to show a Table Box (NOT Chart) look like:
Go to Solution.
You could also do it with preceeding load, but it's a bit harder to understand.
The second part is your's and you get 6 rows. In preceeding load (first part) I just aggregated the max values.
You have to be careful - these versions only work when you have one W and one M transaction - otherwise you should use some other aggregation function.
Hi,I would do it with LEFT JOIN, like this:
LOAD ACT AS Final.Act , COEF AS Final.WorkerCoef RESIDENT Act Where PARAM = 'W'; Left Join(FinalAct) LOAD ACT AS Final.Act , COEF AS Final.MachineCoef RESIDENT Act Where PARAM = 'M';
Thanks Miha - It's Works!
In your answer the script run twice on the Act table.
Maybe there a way to go over Act only once?
Thks again -
Thank you Miha.
Thats exactly what I was looking for.