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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SetAnalysis

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

2 Replies
IAMDV
Master II
Master II

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.

Not applicable
Author

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