Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dshaka2000
Contributor
Contributor

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
Luminary Alumni
Luminary Alumni

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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

dshaka2000
Contributor
Contributor
Author

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

Not applicable

Please post a sample QVW

dshaka2000
Contributor
Contributor
Author

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

dshaka2000
Contributor
Contributor
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.