Discussion Board for collaboration related to QlikView App Development.
I have a pivot table with multiple fields. Some are: AS, AVAIL . When I select CI I only want to return the AS and AVAIL that have been assigned to the CI. I currently have a Join I thought would work but it is giving values for the other affected services in addition to the one I select. How can I write an expression to return the values I would like to see only?
AS – affected service; AVAIL – percentage available service duration; CI – name of the customer who has been impacted by down service.
Join(Impacts) LOAD * INLINE [
display_impact_customer, impact_customer, impact_affected_service
Cust1, Sys 1
Cust1, Sys 2
Cust2, Sys 3
It is pretty hard to guide you with this information.
I would suggest you to share the QVW file with sample data which describes your problem.
If you are asking about Dimensions then use "Enable Conditional" option for that particular dimension when select using
getfieldselections , if you are thinking about measures, goto presentation tab -> select the column and "Hide column" option and write a conditional based on your selections