topic SetAnalysis in QlikView

SetAnalysis

Wed, 13 Apr 2011 09:24:36 GMT

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

SetAnalysis

IAMDV — Wed, 13 Apr 2011 09:33:54 GMT

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.

SetAnalysis

Wed, 13 Apr 2011 09:44:09 GMT

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