topic Re: Use If statement in Set Analysis in QlikView

Use If statement in Set Analysis

Wed, 03 May 2017 15:52:52 GMT

Hi,

I want set fiscal year depending fiscal actual month in set analysis expression but it doesn't work.

Here you are the expression i'm using:

=Sum({<Anio={"$(=If(Num(Month(Today()))=10, Max(Anio)-1, Max(Anio)))">} Amount)

Can Anyone help me?

Re: Use If statement in Set Analysis

swuehl — Wed, 03 May 2017 15:57:54 GMT

'Doesn't work' is not a good issue description, could you elaborate a bit more?

What does the dollar sign expansion return (e.g. if you use the expression in a text box)?

How do the field values of field Anio look like? Pure year numbers (integers)?

Re: Use If statement in Set Analysis

Wed, 03 May 2017 16:03:11 GMT

Anio is iqual to: 2016, 2017, etc...

Re: Use If statement in Set Analysis

Wed, 03 May 2017 16:05:36 GMT

I type the next expression and work correctly but I would like to learn apply if condition in set analysis

=if(Num(Month(Date(Today())))=10,

Sum({<Anio={$(=Max(Anio)-1)}>} Amount),

Sum(Amount)

)

Re: Use If statement in Set Analysis

neelamsaroha157 — Wed, 03 May 2017 16:09:40 GMT

Sum({$<Anio={"$(=If(Num(Month(Today()))=10,Max(Anio)-1,Max(Anio)))"}>}Amount)

I guess you are missing one of the parenthesis.

Re: Use If statement in Set Analysis

Anil_Babu_Samineni — Wed, 03 May 2017 16:10:33 GMT

This is the case, This one is good approach as per my experience. Because, You are displaying the values for Amount when condition is satisfy. or else second value. I am assuming this one is good one only. Let's wait for reply from Experts

Re: Use If statement in Set Analysis

Wed, 03 May 2017 16:28:15 GMT

wow!

Yes, that right; i was missing one of the parenthesis.

Thanks very much Neelam.

Re: Use If statement in Set Analysis

Wed, 03 May 2017 18:26:28 GMT

this expression only apply if you want to display the information y text objet but. really i'm using this expresion with simple condition, so I'm not using the second condition.

for example you can to have a pivot table displaying sales for actual month and last month but if the fiscal year is staring (depending of month) you have to go to past year.

My fiscal year start in Octuber; it means that this month one but my last month belongs to past year because the new fiscal year is staring again.

I hope you understand!

Re: Use If statement in Set Analysis

neelamsaroha157 — Wed, 03 May 2017 18:32:03 GMT

Can you share sample data with expected output.

Re: Use If statement in Set Analysis

neelamsaroha157 — Wed, 03 May 2017 18:34:26 GMT

I am not sure if you have Fiscal calendar built in your application, if not, then you may consider this.

Fiscal and Standard Calendar generation

Fiscal Year

Re: Use If statement in Set Analysis

Anil_Babu_Samineni — Thu, 04 May 2017 02:04:15 GMT

The reason i am asking you is i am not clear with that expression. Would you share atleast data set and may be helpful to you if you know the result set as well. Please post on wall if possible