Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

Hello,

I have display value till the selected year and month-1.

But for 1 specific "item no" there is no entry for 2012 - April. so it is not calculating any value and shows 0.

For 2012-May, there is entry in DB, so it is showing value.

So how to do calculation in such scenario.

I have attached qvw with sample data.

0 Replies