topic How to limit rows number? in QlikView

How to limit rows number?

Tue, 16 Nov 2010 10:06:45 GMT

Hi,

Can anyone tell me how to display only these rows that have 'Nie' value in last column?

Thanks

How to limit rows number?

Miguel_Angel_Baeyens — Tue, 16 Nov 2010 10:39:37 GMT

Hello,

I'd use set analysis in every expression, so Naleznosc column, for example, would look like the following (I don't have polish characters)

Sum({< [Czy rozliczony] = {'Nie'} >} Amount)

The bold part is the set analysis, which is what you should add to all expressions in chart.

Hope it helps.

How to limit rows number?

Tue, 16 Nov 2010 10:40:44 GMT

hello,

you can use set analysis in your expression:

sum( {$ <[Czy rozlyczony] = {'Nie'}> } kwot_rozl)

where $ means current user selections are considered except what is in the <>-brackets.

HtH

Roland

How to limit rows number?

Tue, 16 Nov 2010 10:48:49 GMT

Hi,

Thanks. I am not sure if I can use set analysis in each column formula because two columns do not use aggregation

Nale?no?? = only(Nale?no??)

Zobowi?zanie = only (Zobowi?zanie)

Can I still do it without using aggregation?

How to limit rows number?

Miguel_Angel_Baeyens — Tue, 16 Nov 2010 10:58:22 GMT

Hi,

Actually, Only() function is an aggregation function. If the field or expresion has more than one value, it will return null. According to this, you can add set analysis to the Only() function:

only({< [Czy rozliczony] = {'Nie'} >} Nale?no??)

Hope that helps