Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Selecting data which are not in current user selection

Hi everybody,

i just have another tricky problem to solve.

First: Attached you can find the example.qvw file 😉

Okay, let's begin to explain (which is often not really easy^^):

There are 2 tables in my datamodel:

- the first table (SALESFORCE) contains all sales data (won AND lost offers - 15%, 50% and 100%)

- the second table (SAP) contains only billing relevant offers (only won offers - 100%)

This tables are connected (keys) via the SAP-ID in both tables:

qv0.png

Now I create a new table to display all sales data (no selection in the application):

qv1.png

Fine 😉 ... but it only works fine WITHOUT selections ... 😕

Now I want to select only ONE year (e.g. "2011") and take a look - the values with 15% and 50% are missing in the table:

qv2.png

It is very necessary to select the year from the SAP data because this is a huge qvw-application and different other items are dipendent from that selection.

Is there any possibility to select the 15%, 50% AND 100% rows from the table by chosing a year?

Thank you for every input 🙂

jup

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

hi,

can't say I understand what you are trying to do but I have managed to do it in the attached qv.

created a variable to take the value of Sap_Year. then test the value of the variable to see if a Year is selected, if it is use set analysis to get your result if not use your original expression without set analysis.

I am sure there are people out there who could find a better way, but I can give you this!

View solution in original post

3 Replies
Highlighted
Creator III
Creator III

use the year field from the salesforce application

Highlighted
Not applicable

Hi Tjeerd,

I have to use the SAP year because its a very large app and other items are affected by this selection.

I need another solution.

jup

Highlighted
Specialist
Specialist

hi,

can't say I understand what you are trying to do but I have managed to do it in the attached qv.

created a variable to take the value of Sap_Year. then test the value of the variable to see if a Year is selected, if it is use set analysis to get your result if not use your original expression without set analysis.

I am sure there are people out there who could find a better way, but I can give you this!

View solution in original post