topic Re: Conditional row display in straight table in QlikView

Conditional row display in straight table

Anonymous — Mon, 03 Oct 2011 22:03:08 GMT

I am very new, so this is probably an easy thing that I just can't do as a beginner.

I have a straight table that is counting degrees for a given student.

I only want to display the rows where degree-count is greater than 1.

I tried the following 'if', but it does not omit the counts that = 1.

Any ideas on how to apply a condition to this expression?

if(count([Degree Counter] > 1),count([Degree Counter]), null())

Re: Conditional row display in straight table

Tue, 04 Oct 2011 02:32:27 GMT

Try this sum(if(aggr(count([Degree Counter],student)>1,count([Degree Counter]))

Regards,

Kiran.

Re: Conditional row display in straight table

Anonymous — Tue, 04 Oct 2011 14:15:38 GMT

I modified your suggestion by replacing <student> with <Name> assuming that was to be the unique 'group by' field.

I had to add two end-parenthesis and I was not clear on where to add them. Now I do not get any rows in my table.

Do you see any issue with what I've done?

sum(if(aggr(count([Degree Counter]),Name) >1,count([Degree Counter])))

Re: Conditional row display in straight table

Anonymous — Tue, 04 Oct 2011 14:37:35 GMT

I modified your suggestion by replacing <student> with <Name> assuming that was to be the unique 'group by' field.

I had to add two end-parenthesis and I was not clear on where to add them. Now I do not get any rows in my table.

Do you see any issue with what I've done?

sum(if(aggr(count( [Degree Counter] ),Name) >1,count( [Degree Counter] )))

Conditional row display in straight table

vgutkovsky — Tue, 04 Oct 2011 15:58:02 GMT

You can do this without aggr, which will be much lighter in terms of memory and CPU consumption: sum({<Name={"=sum([Degree Counter])>1"}>}[Degree Counter])

Note that this assumes that "Degree Counter" is a flag that can be summed, and is joined correctly to the rest of your data model. If you post a reduced example app, I can check it for you in case this produces unexpected results.

Regards,

Vlad

Conditional row display in straight table

Anonymous — Tue, 04 Oct 2011 16:09:25 GMT

Thank you so very much!