Specific Filters

[#1]

I have a concatenated table - there is a field named "Table" which differentiates between the two table types (Table 1, Table 2 .....)

I have a graph that is using data from all tables but if I apply a date filter I want the selection to affect the information in but "Table 1"

please can you help?

[AbhijitBansode]

if you want data from Table 1 only then use set analysis in your expressions like;

sum( { < table= {'Table 1'} > } Sales)

[jonathandienst]

Qlikview field names are case sensitive. Use

Sum({<Table = {'Table 1'}>} Sales)

HTH

Jonathan

[Anonymous]

sum( { < only(table)= {'Table 1'} > } Sales)

[#5]

I think this is all along the right lines however maybe I haven't explained properly.

Table 1 has date information, Table 2 does not.

I want to sum up "amount" in table 2 based on the date range selected in table 1.

if(If(Table='Table 1', Sum(Amount 1))>0,sum(Amount 2))

[ashishkalia]

Drew Lees ! PFA
this may help

if u want some thing else then this may help.

[jonathandienst]

Reread your post. Do you want to exclude Table1 if any date is selected? Something like this:

     If(GetSelectedCount(Date) > 0, Sum({<Table-={'Table1'}>} Sales), Sum(Sales))

HTH

Jonathan