topic Help with displaying data under 9999 in QlikView

Help with displaying data under 9999

hopkinsc — Thu, 15 Jul 2010 16:54:23 GMT

Hi, i have attached a file that i need help with.

I only want to display data in the pivot table that is less than 10000, i,e, from 1-9999. All other data i want to exclude. The data is loaded in from a database that i can't access, so all data is loaded in but i dont want to display all data.

Any help would be appreciated.

Thanks

Help with displaying data under 9999

Thu, 15 Jul 2010 17:11:06 GMT

Lets say the field you want to filter is called Amt...

Using this as your expression will treat values 10,000 and greater as null

if(Amt>=10000,null(),Amt)

Help with displaying data under 9999

Miguel_Angel_Baeyens — Thu, 15 Jul 2010 17:24:10 GMT

Hello again,

Try using

Only({< EAN = {'<=10000'} >} EAN)

as expression.

Help with displaying data under 9999

rwunderlich — Fri, 16 Jul 2010 05:54:18 GMT

I'm guessing EAN is to be a dimension of the Pivot Table. In that case, use a calculated dimension of:

=if(EAN<10000,EAN)

See attached example.

-Rob