I've read that using set analysis can perform much faster than conditional if statements. I have a scatterplot chart that uses one dimension with 2 expressions - one expression is a field - the other expression is conditional based on what is selected in a listbox.
I'm attaching an example where I am using a conditional statement for one of the expressions in the scatterplot based on the selection in the listbox. How would I use set analysis for this example?
I am using this conditional expression in a variety of places on my application and want try to make the rendering of these charts and objects faster.
Set analysis will not help you here. Set analysis is in principle like a selection that is made for that expression only, and is evaluated before the expression is calculated.
In your case, you have a data model with two unconnected tables that looks like
and then you use an if function in the scatter chart to create a link between S_ID and the right number in the left table. This type of logic is exactly what QlikView is good at. So I would instead build this logic into the data model:
Crosstable (S_ID, number,2)
'number_' & S_ID as S_ID
FROM Selection.txt ;
and then you need to change your scatter chart to use the following two expressions instead: