Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I write an expression for a pivot table to present values I select.

 

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.

 

Example

Join(Impacts) LOAD * INLINE [
display_impact_customer, impact_customer, impact_affected_service
Cust1, Sys 1
Cust1, Sys 2
Cust2, Sys 3
Cust3,Sys3
Cust3, Sys2
Cust4, Sys1

Cust5, Sys2
Cust6, Sys1
Cust6, Sys3
Cust7, Sys2
Cust8, Sys2

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Dear Dennis,

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.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
kkkumar82
Specialist III
Specialist III

Hi Dennis,

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

Anonymous
Not applicable
Author

To turn this data into a dynamic visual presentation has been challenging.  I have added data fields:

Not applicable
Author

Please post a sample QVW

Anonymous
Not applicable
Author

Here is the .qvw. This isn't the best data to work with which is part of the problem

Anonymous
Not applicable
Author

Is anyone available to help me on my .qvw this weekend via a screen share? If so, let me know a good time and I'll provide the meeting details.