topic Re: expression on dimention in QlikView

expression on dimention

Anonymous — Sun, 22 Nov 2015 06:48:00 GMT

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?

Re: expression on dimention

marcus_sommer — Sun, 22 Nov 2015 10:54:59 GMT

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

Re: expression on dimention

Anonymous — Mon, 23 Nov 2015 09:52:05 GMT

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

Re: expression on dimention

marcus_sommer — Mon, 23 Nov 2015 17:29:23 GMT

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

Re: expression on dimention

Anonymous — Tue, 24 Nov 2015 04:45:06 GMT

So thanks again for help Marcus