Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with 5 columns Name, Date, ID, Rate, Type
Now I want that whenever column 'Name', 'Date' & 'ID' is selected among all the other columns and they have the same 'Rate' then change 'Type' to 'Unsure'
Name | Date | Id | Rate | Type |
John | 10th Aug | 1122 | 1 | True |
Ron | 15th Aug | 1344 | 1 | False |
Steve | 13th July | 1122 | 5 | False |
John | 15th Sept | 2113 | 3 | False |
Molly | 2nd June | 4841 | 1 | True |
Result:
Name | Date | Id | Rate | Type |
John | 10th Aug | 1122 | 1 | Unsure |
Ron | 15th Aug | 1344 | 1 | Unsure |
Steve | 13th July | 1122 | 5 | False |
John | 15th Sept | 2113 | 3 | False |
Molly | 2nd June | 4841 | 1 | Unsure |
Thanks!
This would need to be done in the load script which is going to be fairly complex task if you are new to things. If you can attach what you have in the way of QVW file, someone may be willing to have a look and help out, but expecting someone to write everything for you is not something I would expect to happen.
Basically, you would need to load the data, group it into the correct order using Group by or Order by function and then do another pass through looking for your sequence and modifying the field data if things are true etc.
Here is a link to the Design Blog area you can use to search posts there, they are mostly how-to, so may be of some help to you in sorting things out on your own.
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett