Hello,
My experience with Qlik is very limited and have this situation that my data source has two Date Fields; ‘policy_eff’ and ‘entry_date’ with every record. A Policy can be sold on one date, however the effective date (policy_eff) can be another, even on a future date. Furthermore, users want to have a radio button option that I’ve found to filter all the visualizations filtered by either Effective date or Entry date. While this radio button will take a field value, I need to create a field to add to the radio button's dimension which will have for example values; Effective date OR Entry date.
policy | policy_type | broker_state | rep | premium | livecount | product | product_name | policy_eff | entry_date |
XYZ526490 | D | NJ | 027 | 125 | 2 | INS | D | 1/30/2018 | 2/1/2018 |
XYZ526491 | B | NY | 028 | 125 | 1 | INS | B | 1/16/2018 | 2/1/2018 |
XYZ526493 | M | PA | 030 | 247.2 | 4 | INS | M | 1/31/2018 | 2/1/2018 |
How can I populate Effective date OR Entry date in a field which will take the corresponding date from 'policy_eff’ or ‘entry_date’? How and what can I script in the table to achieve this?
Your suggestion is highly appreciated.
Thank you very much.
