topic Re: Specific Filters in QlikView

Specific Filters

Mon, 29 Sep 2014 12:37:35 GMT

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 — Mon, 29 Sep 2014 12:41:39 GMT

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

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

jonathandienst — Mon, 29 Sep 2014 12:55:23 GMT

Qlikview field names are case sensitive. Use

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

HTH

Jonathan

Anonymous — Mon, 29 Sep 2014 12:56:03 GMT

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

Mon, 29 Sep 2014 12:59:34 GMT

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 — Mon, 29 Sep 2014 13:01:56 GMT

Drew Lees ! PFA
this may help

if u want some thing else then this may help.

jonathandienst — Mon, 29 Sep 2014 13:03:03 GMT

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