topic Re: Transfer selections from current selections to another set in QlikView

Transfer selections from current selections to another set

tinkerz1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a master calendar that reduces the data table for 2 sets of tables from one selection in the master calendar.

These are keys generated in the load script.

[Open Balance Table] KEY_Open Balance Date < Master Calendar > KEY_Fact Date [Fact Table]

> Any selection in master calendar reduces the tables either side

How do I then transfer selections made on the fact table to the Open balance table.

Do I need to use set analysis and get field selections? or is there another way?

COUNT({<Open_Balance_CountryID={[CountryID]}>} CaseID_Open_Balance)

Thanks,

marcus_sommer — Mon, 28 Nov 2016 12:13:09 GMT

Try it with p():

COUNT({<Open_Balance_CountryID=p([CountryID])>} CaseID_Open_Balance)

- Marcus

santiago_respane — Mon, 28 Nov 2016 12:18:12 GMT

I don't fully understand your issue, but for transferring selections from states in set analysis you can do as follows:

=SUM({$<Field1=SetName::Field1>} Field2)

Lets say that we want to sum all values in Sales field on the state X but considering the dates of the current selections, it would be:

=SUM( {X<Date=$::Date>} Sales)

Or sum the budget for all data except for region that will be considered based on current selections:

=SUM({1<Region=$::Region>} Budget)

Hope this helps.

Kind regards,