Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
Luminary Alumni
Luminary Alumni

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