topic Re: set analysis query in QlikView

set analysis query

Tue, 30 Apr 2013 13:22:05 GMT

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

Re: set analysis query

Tue, 30 Apr 2013 13:29:27 GMT

try this

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

Re: set analysis query

Tue, 30 Apr 2013 13:39:02 GMT

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?

Re: set analysis query

Tue, 30 Apr 2013 13:49:35 GMT

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

Thanks

Re: set analysis query

Tue, 30 Apr 2013 14:50:33 GMT

does anyone have any ideas?

Re: set analysis query

pennetzdorfer — Tue, 30 Apr 2013 14:55:19 GMT

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

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

Hope that helps!

Regards,

Florian

Re: set analysis query

Tue, 30 Apr 2013 15:29:56 GMT

Hi, thanks for the reply,

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

Re: set analysis query

kaushiknsolanki — Tue, 30 Apr 2013 16:04:52 GMT

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

Re: set analysis query

Tue, 30 Apr 2013 16:56:15 GMT

Hi, thanks for the reply but it didnt work

Re: set analysis query

Wed, 01 May 2013 05:04:48 GMT

TRY THIS

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

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