topic Re: Dimension Expression: If Clause in QlikView

Dimension Expression: If Clause

Tue, 19 Jul 2011 09:00:20 GMT

Hi Guys,

I have a database that has a list of names and the hours that these people worked. I am busy creating an invoicing checking report and need some help figuring out how to do this one thing in particular.

I want my dimension, which is "Name" to list only names and sum hours for where I have an if clause. The if clause would work like this. If the person has a particular cost code appearing more than once for a particular week, list his name and his hours for where there is a 'duplicate' essentially. How would I do this?

Thanks, Byron

Dimension Expression: If Clause

Tue, 19 Jul 2011 09:21:10 GMT

In my straight table I have this as an expression. I somehow need to add if week ending = weekending (duplicate) to this expression

aggr(sum({$<CategoryDesc={'Labour Charges'}>}Hours),TempName)

Cheers, Byron

Dimension Expression: If Clause

Wed, 20 Jul 2011 07:24:47 GMT

Anyone??? Please help, or ask me to explain again if need be. Thanks, Byron

Dimension Expression: If Clause

lironbaram — Wed, 20 Jul 2011 07:34:04 GMT

hei

can you post sample data

Re: Dimension Expression: If Clause

Wed, 20 Jul 2011 07:59:51 GMT

Please see attached. Cheers

Re: Dimension Expression: If Clause

lironbaram — Wed, 20 Jul 2011 08:26:42 GMT

hei

attach is an example

first icorrected your table

in the expression i add the filed TempName to the aggr fields

second i created new table which diplay only the records where the same Temp Name

in the same wkend

in the same ctdesc

has more then one record

hope its helps you

Re: Dimension Expression: If Clause

Wed, 20 Jul 2011 09:11:02 GMT

Thanks Iiron, we are really close From the sample data I gave you it works PERFECTLY. I'm not sure why in my 'real world' data it is not doing exactly the same. Basically what is happening is that it indicates in the aggr column if the condition is true with a 1 (which is great). For all other fields it is showing a '-' which I know to be Null???? What would I need to change to get it to not show results for items that dont fit the condition i.e. the '-'?

Thanks, Byron

Re: Dimension Expression: If Clause

Wed, 20 Jul 2011 09:22:43 GMT

LOL, just figured it out 'supress when value is null' Thanks for the help Iiron. Works like a charm