topic Set Analysis Help in QlikView

Set Analysis Help

Thu, 08 Aug 2013 12:23:15 GMT

Hi,

I have the following expression :

num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}[Line Total]),'#,###.0%')

I would like to only calculate where the field included_in_analysis='Y' - can anyone advise how can can add this into the above expression please?

Many thanks for you time.

Re: Set Analysis Help

Thu, 08 Aug 2013 12:28:07 GMT

Hi,

num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}, included_in_analysis= {'Y'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}, included_in_analysis= {'Y'} >}[Line Total]),'#,###.0%')

Re: Set Analysis Help

Thu, 08 Aug 2013 12:28:58 GMT

if(included_in_analysis='Y',num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}[Line Total]),'#,###.0%'))