I need to work out building an excel like pivot table in Qlikview and have attached current and desired. The values of Age_Category field shall be the columns in the pivot and the slots will be color codes based on combination of "Conf_Type, EA_outstanding, Risk_profile_confirm and Sum(CountofFXC) crossing a threshold value of 50"
Some script so that the field values be made as columns?
Some reusable script to do color coding based on two three parameters.