set analysis query

[#1]

Can anyone help me to put this set analysis in this expression please. I can't get it to work!

sum(aggr(num([Days Spent Offline]),[Hotel Name],[Room Number],[Offline Date]))

{<[Reporting Week]=, [Reporting Date]={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'},[Reason Group] = {'Upgrade'}>}

thanks

[#2]

try this

sum({<[Reporting Week]=, [Reporting Date]={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'},[Reason Group] = {'Upgrade'}>}[Days Spent Offline])

[#3]

Hi, the aggr is missing from that though so that won't work. i need to combine them both.

Do you have any more ideas?

[#4]

Or if i cant combine the set anaysis with the expression, could someone help me transform it to an if statement?

Thanks

[#5]

does anyone have any ideas?

[pennetzdorfer]

There's an excellent Set Analysis Wizard (thanks to Stefan Walther):

http://tools.qlikblog.at/SetAnalysisWizard/

Hope that helps!

Regards,

Florian

[#7]

Hi, thanks for the reply,

I cant find any option to use AGGR in that wizard unfortunately

[kaushiknsolanki]

Try this.

sum({<[Reporting Week]=, [Reporting Date]={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'},[Reason Group] = {'Upgrade'}>}
aggr(num([Days Spent Offline]),[Hotel Name],[Room Number],[Offline Date]))

Regards,

Kaushik Solanki

[#9]

Hi, thanks for the reply but it didnt work

[#10]

TRY THIS

if([Reporting Date] >= $(vPreviousMonthStart) or [Reporting Date] <= $(vPreviousMonthEnd),

Aggr(sum(num([Days Spent Offline])),[Hotel Name],[Room Number],[Offline Date]))