If Statements

[#1]

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

[senpradip007]

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

[#3]

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

[senpradip007]

PFA

[tresesco]

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

[senpradip007]

Please find the updated one.

[PradeepReddy]

Refer the default QlikView examples provided during the installation.

Dashboard Name :  "What is New in QlikView11"

Report name  : "Product Grouping"

[ToniKautto]

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

[#9]

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

[ToniKautto · Accepted solution]

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.