topic set analysis for a condition? in QlikView

set analysis for a condition?

sushil353 — Wed, 05 Oct 2011 07:57:28 GMT

Hi All,

in my application i have a varialble vfact.

in a expression i used a condition as

if(vfact=1,sum(prd_failures),sum(measurement_failures))

i have used a button to set or reset the variable values...

prd_failures and measurement_failures are fields from different tables...

Is it possible to achieve same functionality using set analysis...

Thanks

Sushil

Wed, 05 Oct 2011 08:04:23 GMT

add in your script a flag (1-0) in both tables so in your front end you can use set analysis about this flag

sushil353 — Wed, 05 Oct 2011 08:45:17 GMT

Hi dedagroup,

Can you give an example to use set analysis.

Thanks

sbaldwin — Wed, 05 Oct 2011 08:46:17 GMT

Hi if you really wanted to use set analysis you could do something like this but the question would be why not just use your If statement??

= sum( {<prd_failures={$(=if(vfact = 1,'*') )} > } prd_failures)/

sum( {<measurement_failures={$(=if(vfact = 1,'*') )} > } measurement_failures)

Thanks

Steve

sushil353 — Wed, 05 Oct 2011 09:00:32 GMT

I dont want to use if statement because my application slows down and takes time to perform calculations

Thanks Sbaldwin

erichshiino — Thu, 06 Oct 2011 13:32:52 GMT

Hi Sushil,

Why don't you set the field directly on your variable like this:

You set vFact to prd_failures or to measurement_failures

Then, your expression will be:

sum( $(vFact))

Hope this helps,

Erich