Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select numbers

How can i select numbers in a pivottable.

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

2 Replies
Miguel_Angel_Baeyens

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

Not applicable
Author

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.