topic Re: Using variable in Set Analysis in QlikView

Using variable in Set Analysis

Wed, 21 Oct 2015 13:02:48 GMT

Hi There,

I am trying to use a variable (declared in the settings not in the load script) in a set analysis but it just does not want to work. Probably I am doing something wrong but I tried already couple of things like single, double quotations. = within the evaluation. Nothing works.

I need to get back data which is less than the value of the variable, but seems within the set analysis the bigger (>), smaller (<) operators just ignored. It gives me back all the results.

Would be happy with any suggestion.

Set Analysis

=COUNT({<[Renewal Month Relative]= {'-1'}, [Current Free Month]={'0'}, [Current Discount]={"<$(vExpCentreEmbeddedDiscount)"}>} [Parent Duration])

Variable (vExpCentreEmbeddedDiscount)

AVG({<[Renewal Month Relative] = {'-1'}>} [Parent Inventory Value])/AVG({<[Renewal Month Relative] = {'-1'}>} [Parent List Price]))

Thanks in advance for your help guys.

Tamas

Re: Using variable in Set Analysis

sunny_talwar — Wed, 21 Oct 2015 15:43:47 GMT

Not sure but may be an equal sign next to the variable might helps:

=COUNT({<[Renewal Month Relative]= {'-1'}, [Current Free Month]={'0'}, [Current Discount]={"<$(=vExpCentreEmbeddedDiscount)"}>} [Parent Duration])

Re: Using variable in Set Analysis

Wed, 21 Oct 2015 15:48:29 GMT

Thanks, it is not working. That was what I already mentioned " = within the evaluation. Nothing works"

Re: Using variable in Set Analysis

sunny_talwar — Wed, 21 Oct 2015 15:53:58 GMT

I apologize, I missed that part of the post

Re: Using variable in Set Analysis

Thu, 22 Oct 2015 09:15:12 GMT

Hi,

I think Set Analisys is correct.

Try put "=" before variable definition, that also need an initial parenthesis:

=(AVG({<[Renewal Month Relative] = {'-1'}>} [Parent Inventory Value])/AVG({<[Renewal Month Relative] = {'-1'}>} [Parent List Price]))

regards!