Comparing groups of records within a table

[#1]

Hi,

Please take a look at this sample application. What I did here was to load my main table (Fruits). Then create two separate identical tables from it in the load script. This way I could then have two identical, but disjoint list boxes of all fruits. Here the user can pick a fruit (or group of fruits) from each one of these two list boxes and the table to the right will compare the average count of the selected fruits from each list box.

My question is this. Can one accomplish this functionality without creating two copies of the original table. My real table has millions of rows and this is not an optimum solution.

[crusader_]

Hi,

Alternate States is solution for your issue.

Read more here How to Comparative Analysis.

PFA.

Hope this helps you.

Andrei

[demoustier]

Like in attached File ?

[#4]

I see now how the Alternate States feature works; however, my requirements are to implement it exactly as in the straight table in my original sample qvw file. Can't seem to be doable with Alternate States.

[demoustier]

In this case, I have no other solution than yours....sorry

[crusader_]

Hi,

Check wether it acceptable for you.

PFA.

Hope this helps.

Andrei

[#7 · Accepted solution]

Perfect. Thanks for your help. Can you explain the $* notation in the expression? Does not look like the set analysis syntax I have seen before:

avg({$*A} [Count])

[crusader_]

Hi,

It's Alternate State syntax in set analysis.

$*A means Selection and State 'A' - intersection give us correct result.

Hope this helps you.

PS please mark my previous answer (correct or helpful) for future users who will have same issue.

Andrei

[#9]

i just notice that another non alternate state list is interfering with my two alternate list boxes.If I have a  third non-alternate state Fruit list box in the app, it affects what the user selects from the alternate state lists. I tried every syntax I could think or researched, but nothing seems to work. Do you know how to include all elements from this list box in the expression, ie, {<Fruit=>}

[crusader_]

Oh, yes... Sorry for this confusion.

I've never faced it before because I haven't used "third" listbox.

To fix this remove $-sign.

avg({A} [Count])

avg({B} [Count])

Regards,

Andrei