Set expression select only necessary dates

vchuprina — Fri, 21 Apr 2017 07:30:16 GMT

Hi All,

In my application I need to have following chart

Year-Month	Product %
	4,28%
2016-04	0,17%
2016-05	4,28%
2016-06	4,19%
2016-07	0,19%
2016-08	4,28%
2016-09	4,28%
2016-10	4,28%
2016-11	4,28%
2016-12	4,28%
2017-01	4,28%
2017-02	4,28%
2017-03	4,27%
2017-04	4,27%

I use expression below:

=sum({$<DateType = {Product},ProductDateKey = P(DateKey),[Item Number]-={"Y*"}, [Date]={">$(=addmonths(today(),-12))"}>}[Quantity] * [Product Weigth])
/
sum({$<DateType = {Operation}, OperationDateKey = P(DateKey),
[Date] = {">$(=addmonths(today(),-12))"} >}[Oper Quantity] * [Operation Weigth])

Chart shows correct data only when I select one year-month value:

Year-Month	Product %
	0,22%
2016-04	0,22%

Year-Month	Product %
	7,26%
2016-08	7,26%

Product and Operation tables have own date fields and they are linked by linkey table which contains - DataKey field

The reason of problem is following: my tables are linked by Item Warehouse and this key is too wide, so in chart I show Product % based on data for all period. If there a way to show correct data by set analysis? Because when I try to use Item Warehouse Date key I lost part of data from Operation table

Re: Set expression select only necessary dates

prachisangewar — Fri, 21 Apr 2017 07:39:29 GMT

Hi,

Can you share a sample of your document?

Re: Set expression select only necessary dates

vchuprina — Fri, 21 Apr 2017 07:50:00 GMT

Unfortunately I can't show client data

topic Re: Set expression select only necessary dates in QlikView

Set expression select only necessary dates

Re: Set expression select only necessary dates

Re: Set expression select only necessary dates