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

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

Anonymous — Wed, 27 Jul 2016 03:07:29 GMT

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

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

kaushiknsolanki — Wed, 27 Jul 2016 08:47:16 GMT

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

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

kkkumar82 — Wed, 27 Jul 2016 09:52:34 GMT

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

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

Anonymous — Thu, 28 Jul 2016 00:37:24 GMT

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

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

Thu, 28 Jul 2016 00:51:06 GMT

Please post a sample QVW

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

Anonymous — Thu, 28 Jul 2016 02:23:30 GMT

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

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

Anonymous — Wed, 03 Aug 2016 19:41:50 GMT

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.