Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Issue because of reduced data based on Year column

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.

 

Labels (1)
4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Issue because of reduced data based on Year column

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?


talk is cheap, supply exceeds demand
Highlighted
Creator II
Creator II

Re: Issue because of reduced data based on Year column

Hi Gyabert,

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

It is very strange.

Thanks

Highlighted
MVP & Luminary
MVP & Luminary

Re: Issue because of reduced data based on Year column

" 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?


talk is cheap, supply exceeds demand
Highlighted
Digital Support
Digital Support

Re: Issue because of reduced data based on Year column

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.