topic Set Analysis - little problem in QlikView

Set Analysis - little problem

Thu, 09 Jul 2009 01:22:39 GMT

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

Set Analysis - little problem

Thu, 09 Jul 2009 02:31:49 GMT

Try this maybe it work

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

Talha

Set Analysis - little problem

Thu, 09 Jul 2009 07:15:45 GMT

That does not solve my problem.

Philippe

Set Analysis - little problem

Thu, 09 Jul 2009 19:53:27 GMT

Hi Philippe,

can you post your .qvw document?

Roberta

Set Analysis - little problem

amit_shetty78 — Thu, 09 Jul 2009 20:41:33 GMT

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.

Set Analysis - little problem

markmccoid — Thu, 09 Jul 2009 20:44:00 GMT

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

Set Analysis - little problem

Thu, 09 Jul 2009 20:58:56 GMT

Amit,

That works perfectly .....

Thanks

Philippe