Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Result not correct with Set Analysis + Filter condition

Hi All,

I have a problem when we have a pre-defined expressions(calculation with set analysis),it seems the expression will apply first on the table, then the search condition. However, the result should not show any data, instead, it shows the result of the set analysis + the filter condition which is not correct.  Can someone please advise?

For example:

We have a straight table with an expression that filters the data for “Toyota” (Car Dimension) using Set Analysis.

Now, we filter the data via search for “Honda” (Car Dimension), the output still shows the data for “Toyota” (Car Dimension).  Even though we do not have any data for “Honda”.  

3 Replies

Re: Result not correct with Set Analysis + Filter condition

It's not quite clear what do you want to do? You need to post more informations maybe with a small example but at least with the expressions itself.

In general one of main-features which set analysis offers is the ability to return data which are independent from the current selection-state especially if you used "1" and/or total as qualifier. Further if you used search-expressions inside a variable within the set analysis these expression will be calculated at first global for the entire object and used for each row.

- Marcus

Re: Result not correct with Set Analysis + Filter condition

Allen,  Yup,  as Marcus said, that is how Set Analysis works.  Selecting “Toyota”  in your Set Analysis overrides any selection made outside of the Set Analysis itself.  When you get used to that you'll be starting to understand how powerful can be.


Re: Result not correct with Set Analysis + Filter condition

result is correct

if you have something like

sum({$ <car={toyota}>} val))

you get sum of val for toyota, also when you choose a different car in the listbox

if you want the sum of the car you choose in the listbox,


or I'm missing something?

Community Browser