topic Re: If Statements in QlikView

If Statements

Thu, 22 May 2014 11:51:00 GMT

Hi Guys,

help me with the If statement ....I have salespersons in a chart with months so I want to see how 1 sales person is performing against other salespeople in each month

Thanks

Re: If Statements

senpradip007 — Thu, 22 May 2014 11:54:18 GMT

You can create two Alternate State. With these you can create a comperative study of two sales persons.

Re: If Statements

Thu, 22 May 2014 12:00:43 GMT

please explain in more detail, can you please give an example

Re: Re: If Statements

senpradip007 — Thu, 22 May 2014 12:10:10 GMT

PFA

Re: If Statements

tresB — Thu, 22 May 2014 12:11:01 GMT

Have a look at trellis (dimension tab). Take two dimnesions, Month and SalesPerson.

Re: Re: If Statements

senpradip007 — Thu, 22 May 2014 12:15:45 GMT

Please find the updated one.

Re: If Statements

PradeepReddy — Thu, 22 May 2014 12:18:20 GMT

Refer the default QlikView examples provided during the installation.

Dashboard Name : "What is New in QlikView11"

Report name : "Product Grouping"

Re: If Statements

ToniKautto — Thu, 22 May 2014 12:23:04 GMT

There are several ways to make the comparison of sales persons. The solution depends a bit on your data model and what the presentation requirements are.

The calculation it self should be possible to do without IF statements. For example with the Alternate States example or my set analysis based example.

A good way to get solution inspiration is to explore the demo site and see if you can find something that looks like the application you are trying to construct.

Qlik Demos: See QlikView in Action

Re: If Statements

Thu, 22 May 2014 12:29:59 GMT

I have tried other methods they work fine, I just want to know how to use it in an if statement, eg. in my if statement i want to focus on a specific SalesPerson, (if the SalespersonName('Palesa') then show her Sales against other sales people else show all the sales)..... How can i write that statement in my expression

Re: If Statements

ToniKautto — Thu, 22 May 2014 12:55:47 GMT

The answer to that question depends on the dimensionality of the calculation. If the Sales person is not in the dimensions, then you can find and compare the persons with IF statements.

The reason for this is that data grouped over for example Month=Jan will have values for both Adam and Bob, and there for you can find these with an IF statement.

If you instead have the SalesPerson as a dimension, the grouping will be different. In a data group with Month=Jan and SalesPerson=Adam, there for example is no data related to the SalesPerson=Bob. An IF statement looking for Bob's data will therefore not find any matches and the result will be empty. In this case the sum is 0, since a sum of nothing is 0.

Re: If Statements

Thu, 22 May 2014 13:14:33 GMT

Try this

if(SalespersonName='Palesa',Aggr(NODISTINCT Sum({<SalespersonName={"Pol"}>} SalesAmount), Month), sum(SalesAmount))

Regards,

Chinni Kanna