topic Re: Help In Set Analysis Expression? in QlikView

Help In Set Analysis Expression?

sandeepprasad_j — Fri, 27 Feb 2015 09:12:10 GMT

Hello Experts,

Can you please help me in writing the set analysis expression for the below if condition

If(vPer=12,sum([Amt]),(if(vPer=6, sum([Amt]))))

Thanks in advance

Cheers

Sandeep

Re: Help In Set Analysis Expression?

tresB — Fri, 27 Feb 2015 09:24:02 GMT

Your expression doesn't look very promising. Or, may be a set analysis would not help here much.

Could you explain the context? Is this expression being used in a chart (if yes, what are the dimensions?) or ..?

Re: Help In Set Analysis Expression?

mightyqlikers — Fri, 27 Feb 2015 09:24:56 GMT

Hi Sandeep

use below expression

=Sum({<vPer={"6","12"}>}Amt)

Regards

Samwise

Re: Help In Set Analysis Expression?

jyothish8807 — Fri, 27 Feb 2015 09:27:09 GMT

Hi Sangeep,

Try like this:

sum({<vPer={'6','12'}>}[Amt])

Regards

Re: Help In Set Analysis Expression?

PrashantSangle — Fri, 27 Feb 2015 09:31:10 GMT

Hi,

Try like,

sum(if(vPer=12,Amt,if(vPer=6,Amt)))

Regards

Re: Help In Set Analysis Expression?

sandeepprasad_j — Fri, 27 Feb 2015 09:31:31 GMT

Thanks for all the replies but the expression is like

If(vPeriod=12,sum([ 12 Amt]),(if(vPeriod=6, sum([6 Amt]))))

Cheers ,

Sandeep.

Re: Help In Set Analysis Expression?

PrashantSangle — Fri, 27 Feb 2015 09:33:42 GMT

Hi,

[12 Amt] and [6 Amt] is fieldName??

Try like

sum(if(vPer=12,[12 Amt],if(vPer=6,[6 Amt])))

Regards

Re: Help In Set Analysis Expression?

sandeepprasad_j — Fri, 27 Feb 2015 09:41:54 GMT

Hello Max,

Yes,those are field name [12 Amt] and [6 Amt]

and code like (001,002) is the dimension for the chart

Re: Help In Set Analysis Expression?

sandeepprasad_j — Fri, 27 Feb 2015 09:43:44 GMT

The dimension is the Code like 001,002 and the expressions is a above

If(vPeriod=12,sum([ 12 Amt]),(if(vPeriod=6, sum([6 Amt]))))

vperios is variable

[ 12 Amt] and [6 Amt] are the fields

Re: Help In Set Analysis Expression?

PrashantSangle — Fri, 27 Feb 2015 09:47:38 GMT

Hi,

Then try the solution which i have given in my earlier post.

Regards

Re: Help In Set Analysis Expression?

tresB — Fri, 27 Feb 2015 09:54:55 GMT

Here set analysis would not be required. Don't worry about using it. Carry on with your expression.

Re: Help In Set Analysis Expression?

sandeepprasad_j — Fri, 27 Feb 2015 09:56:42 GMT

Thanks everyone for your help

Cheers

Re: Help In Set Analysis Expression?

smaqsood_cv — Fri, 27 Feb 2015 10:09:30 GMT

Hi,

You can use something like this

Sum(Pick(match(vPer,{vListOfFieldName}),{vListOfActualField}))

where

vListOfFieldName is a variable which is a concatenated list (& comma separated) of part of the field names that matches your vPer values

vListOfActualField is another variable which is a concatenated list of actual fields

E.g: if vPer values are 6, 12

then, vListOfFieldName = 6, 12

vListOfActualField = [6 Amt], [12 Amt]