Set Analysis - little problem

[#1]

Hi,

I am using Set analysis to compare the amount of reservation of an hotel vs the hotels in the same region.

I have a variable Vregion = to only(Region).

The name of the hotel selected is SmNomHotel.

The expression below does not work (messages too few parameters .... )

sum({$< Region = {$(Vregion)} , SmNomHotel = >} ([Montant de la réservation] / 1000))

Thanks for your help.

Philippe

[#2]

Try this maybe it work

sum({$< Region = {$(Vregion)} , SmNomHotel >} ([Montant de la réservation] / 1000))

Talha

[#3]

That does not solve my problem.

Philippe

[#4]

Hi Philippe,

can you post your .qvw document?

Roberta

[amit_shetty78 · Accepted solution]

Pls try if this works or as suggested pls upload the your qvw.

sum({$< Region = {'$(Vregion)'} , SmNomHotel = >} ([Montant de la réservation] / 1000))

Thanks, Amit.

[markmccoid]

Hi,

Make sure your variable "Only(Region)" is being evaluated in the expression. I usually will put an equal sign in the variable definition "=Only(Region)".

Also, when I have a complex expression I will not put a label on the expression so that I can see how QV is evaluating my code.

Mark

[#7]

Amit,

That works perfectly .....

Thanks

Philippe