Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm new to qlik and constantly find new challenges.
hope that someone can help me.
One of my Fields is called:
Vehicle Status
It gives me 4 options
0
1
2
3
How do I change the name of my 4 options?
0 = New Vehicle
1 = Used Vehicle
2 = Demo Vehicle
3 = Customer Vehicle
And how do I leave out one value from the table?
Many thanks
/Michael
You could use a pick(match()) function or a mapping-table for it:
...
pick(match([Vehicle Status], 0,1,2,3), 'New', 'Used', 'Demo', 'Customer') & ' Vehicle' as [Vehicle Name]
...
Get started with developing qlik datamodels
- Marcus
You could use a pick(match()) function or a mapping-table for it:
...
pick(match([Vehicle Status], 0,1,2,3), 'New', 'Used', 'Demo', 'Customer') & ' Vehicle' as [Vehicle Name]
...
Get started with developing qlik datamodels
- Marcus
You can do this in the script like this:
LOAD [Vehicle Status],
Pick([Vehicle Status] + 1), 'New Vehicle', 'Used Vehicle', 'Demo Vehicle', 'Customer Vehicle') as New_Vehicle_Status
FROM Source
Hi Sunny
Thanks for your respons
This is my Script now.
But I am get an error when i try to Load.
Not sure what im doing wrong.
Do you know where my error is?
Many thanks
/Michael
You need to put the code I gave you earlier on top of your current load. Line 2
Add a slight modification
LOAD *,
[Vehicle Status],
Pick([Vehicle Status] + 1), 'New Vehicle', 'Used Vehicle', 'Demo Vehicle', 'Customer Vehicle') as New_Vehicle_Status;