expression on dimention

[Anonymous]

Hello to all QlikView experts

i have bellow excel entry:

i want to show a hospital name and date in table, if A>B

where i should insert a condition?

[marcus_sommer · Accepted solution]

It will be depend on many things where the best place is to create/apply a condition. In general I would check this order:

1. a flag-field within the script // useful if it's not depending on user-selection or aggregation

2. a condition within an expression  // nearly always applicable by hiding NULL

3. a condition within a dimension // could have disadvantages by performance and usability

1. if(A>B, true(), false()) as FlagField

2. if(A>B, sum(value))

3. if(A>B, [Hospital name])

- Marcus

[Anonymous]

Hello Marcus

Thank's for your explanations

In option 2, where i should write this condition? in condition or in definition area?

In option 3, if we have several dimensions, we should write this condition for all of them?in "condition" area or "edit" area?

sorry for these simple questions? i'm beginner

[marcus_sommer]

By both options (2. and 3.) come the expression respectively the dimension-condition (one dimension is enough) into the definition area - what didn't be true will be return NULL and this could be hidden for each single dimension and globally for all expressions (in tab presentation). Play a bit with them, it's not so difficult and you will learn from things they work and which didn't work.

- Marcus

[Anonymous]

So thanks again for help Marcus