Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table named Data. I tried concatenating two of the rows into one table. My code is shown below:
But I noticed that Qlikview inserts a Ranking = '-'. Can anybody tell me why this is and how to fix it?
Would appreciate any help.
Thanks.
Joel
Try adding a where statement
MRB:
LOAD 'Financial Reward' as Factor,
[Financial Reward] as Ranking
Resident Data
Where Len(Trim([Financial Reward])) > 0;
Concatenate (MRB)
LOAD 'Prestige' as Factor,
Prestige as Ranking
Resident Data
Where Len(Trim(Prestige )) > 0;
Try adding a where statement
MRB:
LOAD 'Financial Reward' as Factor,
[Financial Reward] as Ranking
Resident Data
Where Len(Trim([Financial Reward])) > 0;
Concatenate (MRB)
LOAD 'Prestige' as Factor,
Prestige as Ranking
Resident Data
Where Len(Trim(Prestige )) > 0;
Hi Sunny,
Thanks for your reply but the code didn't work. I still have the "-" values in the Ranking field.
It's weird that if I load a single table I get values = 1,2,3,4,5,6 and no "-" values.
Hmmm...
Hi Sunny,
Figured it out. Just modified your code into:
WHERE NUM([Financial Reward]) > 0
Thanks for your help.
Joel