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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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