topic Re: Select numbers in QlikView

Select numbers

Fri, 15 Jun 2012 08:23:02 GMT

How can i select numbers in a pivottable.

For example i only want to see numbers 4000, 4030, 4415, 8060 to 8500.

Miguel_Angel_Baeyens — Fri, 15 Jun 2012 08:29:39 GMT

Hi,

In what expression do you want to see them? Let's say you are doing a sum of sales.

Sum({< CDGRBREKENING = {4000, 4030, 4415, '>=8060<=8500'} >} Sales)

That will return the sum of values in field Sales for those values only.

Hope that helps.

Miguel

Fri, 15 Jun 2012 08:41:38 GMT

If you want to select those, you could create a selectbox having the "grootboeknummer" as a separate attribute

In the listbox you could use this expression:

4000 4030 4415 >=8060<=8500

Make sure your listbox is in AND mode (option on the general tab "use normal search") (otherwise it will search for >=8060 OR <=8500 (....)

Hope it helps.