topic Re: Select same week from two tables in QlikView

Select same week from two tables

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

I have two tables with same week but dimension names are not same. (Can not rename to same, because it will cause synthetic problems.)

One Sales_Week, one Supplier_Week. I have to choose 202026 from Sales_Week, then choose 202026 again from Supplier_Week to have a same view. Is there any way to choose once instead of choose twice?

Re: Select same week from two tables

Vegar — Tue, 02 Jun 2020 17:17:59 GMT

I see three possible solutions

1. Make selection in one dimension and apply these selections in an set analysis expression for the other dimension.

Eg. Make selection in sales week and calculate with set on Supplier week. Sum({<SupplierWeek=P(SalesWeek)>}Amount

2. Create a data Island calendar that is not attached to the data model and do a similar approach as above for calculations.

Sum({<SupplierWeek=P(IslandWeek),SalesWeek=P(IslandWeek)>}Amount

3. Work with onSelection triggers intin the document totto selections in one field when done in another.

Re: Select same week from two tables

YJ_SG — Wed, 10 Jun 2020 07:14:28 GMT

Hi Vegar,

Prefer option 2. It works well for me.

2. Create a data Island calendar that is not attached to the data model and do a similar approach as above for calculations.

Sum({<SupplierWeek=P(IslandWeek),SalesWeek=P(IslandWeek)>}Amount