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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
RC_121985
Contributor III
Contributor III

Showing Top 10 in Qlik Sense Pivot while using Set Analysis

Namaste,

I am using below Set analysis for showing the balance of a Business Line as on "Keydate"(KeyDate_Pr_Month)

(Sum({<POSTDATE={"<=$(=(KeyDate))"},CLEARDATE={">$(=(KeyDate))"}>}USD)+
Sum({<POSTDATE={"<=$(=(KeyDate))"},CLEARSTATUS={'OPEN'}>}USD))/1000

It is giving correct result in My Pivot, Now i am trying to show Top 10 Business line only in Pivot how do i achieve it.

I tried Vizlib Pivot to show Top 10 but issue is after 10 items it is showing other as well as Null. I just want to see Top 10 nothing else.

Any suggestion?

Thanks

 

 

1 Reply
Qlik1_User1
Specialist
Specialist

@RC_121985 

In Pivot Table there will be an option to include or exclude NULL values under each dimension, use that check box it will solve the purpose.