Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
if you want data from Table 1 only then use set analysis in your expressions like;
sum( { < table= {'Table 1'} > } Sales)
Qlikview field names are case sensitive. Use
Sum({<Table = {'Table 1'}>} Sales)
HTH
Jonathan
sum( { < only(table)= {'Table 1'} > } Sales)
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))
Drew Lees ! PFA
this may help
if u want some thing else then this may help.
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