topic Re: If Condition in QlikView

If Condition

rkpatelqlikview — Tue, 12 Dec 2017 05:12:11 GMT

Hi,

Am showing the trend analysis weekly wise with symbols.

=if( sum({$<WEEK={$(=Max(WEEK))}>}Sales) < sum({$<WEEK={$(=Max(WEEK)-1)}>}Sales) , 0,1)

When am using this expression its comparing last week sales even the last week is not in present that week is treated as '0'.

For Example:

Week Sales

32 100

33 200

34 150

37 300

When am using that expression its taking 36th week as '0'. but i need to compare with last week if its '0' and compare with last of last week even if its '0' it should compare with another previous week. How to write the condition?

Thanks in advance

Re: If Condition

Anil_Babu_Samineni — Tue, 12 Dec 2017 05:34:39 GMT

condition seems okay, Perhaps anyone of these?

=if(sum({$<WEEK={'$(=Max(WEEK))'}>}Sales) < sum({$<WEEK={'$(=Max(WEEK-1))'}>}Sales) , 0,1)

If(Sum(Sales) < Above(Sum(Sales)), 0,1) -- And sorting order should be Ascending

If you are using more than QV12, You can try this too

Aggr(If(Sum(Sales) < Above(Sum(Sales)), 0,1), (WEEK, (NUMERIC, ASCENDING)))

Re: If Condition

luismadriz — Tue, 12 Dec 2017 06:17:15 GMT

Hi,

Is this what you're after? I'm confused about the 36th week...

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 06:20:35 GMT

Thanks for your response Anil.

=if(sum({$<WEEK={'$(=Max(WEEK))'}>}Sales) < sum({$<WEEK={'$(=Max(WEEK-1))'}>}Sales) , 0,1)

Its comparing with the last week.

=If(vovsdhide= 0,1,0)

=(if(ceil( sum({$<WEEK={$(=Max(WEEK))}>}) Sales)*1000)

ceil( sum({$<WEEK={$(=Max(WEEK)-1)}>}Sales)*1000),1,

if(ceil( sum({$<WEEK={$(=Max(WEEK)-1)}>}Saels)*1000)=0,

if(ceil( sum({$<WEEK={$(=Max(WEEK))}>}Sales)*1000)

ceil( sum({$<WEEK={$(=Max(WEEK)-2)}>}Sales)*1000),1,0)

Can i use this?

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 06:22:49 GMT

Thanks Madriz,

There is no sales on 36th ans 35 th week.

This condition i should write in Textobject layout for show and hide purpose.

But little bit of confusing to write Nested IF condition when previous week are no sales.

Re: If Condition

Anil_Babu_Samineni — Tue, 12 Dec 2017 06:25:47 GMT

If you get output, Off course, You can use it!!

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 06:27:38 GMT

Re: If Condition

luismadriz — Tue, 12 Dec 2017 06:34:46 GMT

You could create a MasterWeek table from Min(Week) to Max(Week) in the Load script and then have somehting like this:

Would that help you?

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 06:36:15 GMT

No Anil.

My expression for this wrote in text object layout

=if(ceil( sum({$<WEEK={$(=Max(WEEK))}>}Sales)

ceil( sum({$<WEEK={$(=Max(WEEK)-1)}>}Sales).. When i wrote this exprssion its comparing with last week. Here the last week is 0. its showing wrong symbol

Correct one is below. How will get this with if condition. i thought that there is a nested If need to use.

Re: If Condition

Anil_Babu_Samineni — Tue, 12 Dec 2017 07:01:36 GMT

That means, When you pick 53 there is no 52nd week. And it consider as Null. That means Null / 0 < Value - condition is wrong it should show fails only.. Does this not returned to you?

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 08:10:18 GMT

Yes Anil. There is no 44th Week data/ Transaction. When writing below expression its taking the 44th week is '0' value and calculating its giving the wrong symbol.

This wrote in layout of that symbol text object.

=if(ceil( sum({$<WEEK={$(=Max(WEEK))}>}Sales)

ceil( sum({$<WEEK={$(=Max(WEEK)-1)}>}Sales).

Instead of this ceil( sum({$<WEEK={$(=Max(WEEK)-1)}>}Sales)

can we go for directly transaction week and compare with that value?

Re: If Condition

Anil_Babu_Samineni — Tue, 12 Dec 2017 08:47:44 GMT

May be this?

=if((ceil(sum({$<WEEK={$(=Max(WEEK))}>}Sales) or Not IsNull(ceil(sum({$<WEEK={$(=Max(WEEK))}>}Sales) or Len(Trim(ceil(sum({$<WEEK={$(=Max(WEEK))}>}Sales)))>ceil(sum({$<WEEK={$(=Max(WEEK)-1)}>}Sales)

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 10:39:47 GMT

I will Check it Anil Thanks for you quick response

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 12:37:04 GMT

No Anil. Its not working.

I need some help

The Below is the expression am using in my image text object layout

=if(ceil( sum({$<WEEK={$(=Max(WEEK))}>} [Safety Voilance])/sum({$<WEEK={$(=Max(WEEK))}>}[Kms Travelled])*1000)

ceil( sum({$<WEEK={$(=Max(WEEK)-1)}>}[Safety Voilance])/sum({$<WEEK={$(=Max(WEEK)-1)}>}[Kms Travelled])*1000) 1,0)

But its comparing with last week but i need if there is no week it should skipped that week and compare with the week which is in the x axis.

Weeks are 42 , 43,44,45.

In this current week is 45

so there is no 43 and 44 weeks in my trend then it should compare with 42.

Re: If Condition

Anil_Babu_Samineni — Tue, 12 Dec 2017 12:44:20 GMT

Will you able to provide sample?

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 12:50:26 GMT

Yes Sure. I will do it now

Re: If Condition

rkpatelqlikview — Tue, 12 Dec 2017 13:19:29 GMT

Hi,

There are 4 analysis scr, hr, AR, MR. When you are clicking on anyone it should be show that analysis along with respective symbols. and same for all.

((The trend will show the last 12 weeks of data , the score will be calculated as total number of violations in week / total km driven * 1000 , the score will show green , yellow , red according to the scr value (<20 green , Yellow (20 - 50) , > 50 will show RED)

Thanks in advance

Re: If Condition

Anil_Babu_Samineni — Tue, 12 Dec 2017 15:12:10 GMT

That's lot make sense. But, Difficult to answer without having something?

If(Measure < 20, Image1, If(Measure >20 and Measure <50, Image2, Image3))

Re: If Condition

rkpatelqlikview — Wed, 13 Dec 2017 04:46:31 GMT

Sure Anil. I will provide in details.

Thanks in advance.

KUMAR.

kumardeveloper19@gmail.com

Re: If Condition

Anil_Babu_Samineni — Wed, 13 Dec 2017 05:10:12 GMT

Question answered.. So, No need to reply here. Create one more thread with excellent inputs..