topic Why Set Analysis with variable Increas result instead Decreas. in QlikView

Why Set Analysis with variable Increas result instead Decreas.

yanivvl0 — Sun, 17 Apr 2016 08:59:47 GMT

hi to all , i have a text box tht calculate something like this : sum ( {$<Subject={1},[status]={3}>} amount )

and i have a variable like this : vY = if ( type38=1 or type39=1 , amount , 0 )

when i replace amount with $(vY) i expect to see that the result will Decreas Significantly BUT instead i see Increas ,

what could be the problem ??

i exported the data to another model - and its work OK !?

thanks .

Re: Why Set Analysis with variable Increas result instead Decreas.

phaneendra_kunc — Sun, 17 Apr 2016 09:46:13 GMT

It is hard to tell with out looking at your datamodel. Can you post a sample app.

Re: Why Set Analysis with variable Increas result instead Decreas.

yanivvl0 — Mon, 18 Apr 2016 06:17:38 GMT

hi phaneendra.kunche ,

it is a complicate model and sensitive data , so its a bit difficult to show it .

Anyway, I gave up ... - I solved the problem in the script .

- thanks!

Re: Why Set Analysis with variable Increas result instead Decreas.

sujeetsingh — Mon, 18 Apr 2016 06:23:41 GMT

may be repetition of data? cross joining ? etc

Re: Why Set Analysis with variable Increas result instead Decreas.

Mon, 18 Apr 2016 06:31:38 GMT

Hi Yaniv

If the data works on another model, you are probably changing the 'vY' variable somewhere else in your script

Maybe put a trace on that variable to see if it has the expected value after the load.

Re: Why Set Analysis with variable Increas result instead Decreas.

luciancotea — Mon, 18 Apr 2016 09:10:34 GMT

In the expression of vY, remove the preceding '='

Re: Why Set Analysis with variable Increas result instead Decreas.

swuehl — Mon, 18 Apr 2016 09:25:52 GMT

[Assuming your variable expands to

sum ( {$<Subject={1},[status]={3}>} if ( type38=1 or type39=1 , amount , 0 ) )

it's often a good idea to simplify the expression first, e.g. test with a hard coded expression to eliminate an issue with variable dollar sign expansion

]

What is the relation of fields type38,type39 and amount? Do these fields reside in the same table or in different tables?

If they reside in different tables, QV may need to do a temporary join of tables to make the record-level comparison possible, this may duplicate your amounts in comparison to the first version.