Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am a new learner of QlikView. I come with a question when I am building a new Dashboard for the customer.
I find QlikV seems iew reading data as Case Sensitive approach which caused some data duplication issue to my works.
As shown in below diagram, There are two different values in Fields Selection Box, 'Sea' & 'SEA'.
In operation perspective, it's exactly the same set of data while it is different data in QlikView.
May I know is there a way that we can set the program to read data as case-insentive?
Thanks.
Hasson
No, I don't think so.
But you can convert your values using string functions:
LOAD
Upper(Mode) as Mode,
...
FROM ...;
to convert Sea to SEA (leaving original SEA and AIR as is),
or
LOAD
Capitalize(Mode) as Mode,
...
FROM ...;
to convert SEA to Sea and AIR to Air (leaving original Sea as is).
In both cases, you should get only two distinct values in Mode field.
Hope this helps,
Stefan
If this can occur in multiple fields (across different tables), it is also an idea to put the following instruction in your script before loading any data:
force case upper;
This will make Qlikview turn all values in every field in upper cases and so you can never get into this problem again.
Regards,
Yves
i too think that wont happen in qlikview.
On converting all values to Capital Letter in a particular field using the 'upper(var) as Name', this wont hapen.
Thanks
Renjith Kumaran