Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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”.
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
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.
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?