Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Can you help me with this.
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/ShortageReporting1.qvw]
Attached is my application.
Regards
Sravan
Sravan - Not sure what you mean by checking. However if you wanted to compare last week with current week then you can use simple IF statement like this...
=IF(Sum({<Week={$(vLastWeek)}>} KSTKBAL) = Sum({<Week={$(vCurWeek)}>} KSTKBAL), 'True', 'False')
However, if you are looking for something else... then please can you explain in detail.
Hi DV,
Actually I am trying to achieve the Yellow Line in the Calculcation sheet present in the attached Excel Sheet
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Shortage-Reporting.xlsx]
Seems to be tough as it includes Individual cells.
Thought still i can give a try
hope you can help me
regards
sravan
PS: I need only Weeks from 15 to 17 to be shown and it will change dynamically according to changing Weeks