Issue because of reduced data based on Year column

[kishorj1982]

Hi All, Previously I had 6 years of data but now I have reduced it to 3 years.

I used below reduction formula for this.

Let vStartYear = year(today())-3;

LOAD
Year,
Data,
...
FROM ... where Year >= $(vStartYear);

But in some of my KPIs developers kept Year= blank to avoid any selection on Year column but it sems that because of the same filter my data is not matching.

My expressions are as per below,

OrderBookValueLC= Num (Sum ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} [Orderbook Value LC]), '# ##0')

OrderBook Documents = Num (Count ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} DISTINCT If ([Orderbook Value LC] > 0 OR [Orderbook Value LC] < 0 OR [Orderbook Quantity] > 0 OR [Orderbook Quantity] < 0, [Orderbook Document Number Count])), '# ##0')

OrderBookLines = Num (Count ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} DISTINCT If ([Orderbook Value LC] > 0 OR [Orderbook Value LC] < 0 OR [Orderbook Quantity] > 0 OR [Orderbook Quantity] < 0, [Orderbook Document Item Count])), '# ##0')

Could you please suggest on this.

[Gysbert_Wassenaar]

Can you explain what you mean with "it sems that because of the same filter my data is not matching"?

What is not matching with what? How should it match?

[kishorj1982]

Hi Gyabert,

Because of the blank Year filter in expressions data is not matching.

It is very strange.

Thanks

[Gysbert_Wassenaar]

" Because of the blank Year filter in expressions data is not matching."

What is it not matching? Oranges, cows, 42? For things to match or not you need multiple items and compare one item to another item. What are the different items that you are comparing and do not match?

[Brett_Bleess]

Kishor, were you able to get things worked out on this one?  If so, please consider returning to the thread and posting what the issue was, and then you can mark that post as the solution using the Accept as Solution button too.  It would be nice to know what the issue was here.  I am with Gysbert though, was not really able to follow well on things, as having no values on the expressions seems a bit odd.  What would have likely helped a great deal on this one would have been a sample QVW such that we could look things over in context to try to figure out they why behind things.  Again, please consider posting your solution if you came up with one for the other Community Members, and if you are still working on things, please consider posting an update with some further explanation or even a sample QVW.

Regards,
Brett