topic Re: Set Analysis Query in QlikView

Set Analysis Query

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Please let me know if i can write the Set Analysis for the below code. If so any help on the script.

Question No 1

1 .if(x=0),'Yes','NO').

2. if(x=0 and y=1 , zx-1 ,0)

3. if(x>0 and y<>o or x1=0, Zx-1,0)

Here x,x1,y,z, are the variables.

________________________________________________________________________________

Question No 2

=num(sum(if(date<=enddate and((line=('other') and len(override)=0) or (override= 'other')), (AMountx-1),0))+0,'###,###,(###,###);')

__________________________________________________________________________

Regards,

Pooja.

sunny_talwar — Tue, 14 Jun 2016 18:18:54 GMT

I don't think Question No 1 can be converted to set analysis, unless I am missing something here.

Question No 2

Can be converted to set analysis, but it would be helpful to look at your data model before we propose anything.

Wed, 15 Jun 2016 08:40:14 GMT

Perhaps using your IF logic in the backend script could solve your problem for the first question.

Try this for Question2:

Sum({$<override={'other'},line={'other'},date = {"<=only(enddate)"}>}AMountx-1)

Sun, 19 Jun 2016 05:18:54 GMT

Hi Sunny,

Thanks for your response and i guessed the same for Question 1. I have one more doubt that, can we do this by using 'only' function.?

For question no 2 I I will prepare the data modeling.

Regards,

Pooja

Sun, 19 Jun 2016 05:19:24 GMT

Thanks Pravesh, Will check.