topic Re: Result not correct with Set Analysis + Filter condition in QlikView

Result not correct with Set Analysis + Filter condition

Mon, 29 Jun 2015 17:53:02 GMT

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”.

Re: Result not correct with Set Analysis + Filter condition

marcus_sommer — Mon, 29 Jun 2015 19:09:45 GMT

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

Anonymous — Mon, 29 Jun 2015 19:23:24 GMT

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

maxgro — Mon, 29 Jun 2015 19:26:11 GMT

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,

sum(val)

or I'm missing something?