Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Help with displaying data under 9999

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Help with displaying data under 9999

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)


3 Replies
Not applicable

Help with displaying data under 9999

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

Hello again,

Try using

Only({< EAN = {'<=10000'} >} EAN)
as expression.

MVP & Luminary
MVP & Luminary

Help with displaying data under 9999

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