topic Straight tables comparison in QlikView

Straight tables comparison

Mon, 27 Aug 2012 19:20:28 GMT

Hi,

My requirement is I need to have two straight tables..one table has total level and 2nd table is at user based selection level..table1 shouldn't be changed by user selection..

for example consider my data...

Sales Person Region Sales

A US $100

B CA $200

C EU $300

D AU $400

User Selected AU

Table 1

A US $100

B CA $200

C EU $300

D AU $400

Table 2

D AU $400

Please let me know how to achieve Table 1.

Re: Straight tables comparison

MayilVahanan — Mon, 27 Aug 2012 19:44:13 GMT

Use =Sum({1}RegionSales) as expression in Table1

= Sum(RegionSales) as expression in Table 2

Hope it helps

Re: Straight tables comparison

Anonymous — Mon, 27 Aug 2012 19:47:57 GMT

Hi, you can use Alternate states (comparative analysis) or detach one straight table. Check attached qvw. Alternative is working with set analysis to 'overrule' selections made. But that's a bit more work. Regards, Sander

Re: Straight tables comparison

Anonymous — Mon, 27 Aug 2012 20:07:17 GMT

Ok, the set analysis example was already given to you while I was replying. One remark: the last detach/attach state isn't saved with the doc when you exit. So less usefull. Leaves you with alternate states or set analysis.

Regards, Sander