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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaskar1986
Contributor II
Contributor II

Object level filter in NPrinting

Hi,

I worked on many reports of object level filters with max date function .

requirement is One sheet has default filter with two fields like " if(getselectedcount(field1)=1,max(field1),max(field2)"

so now how to add this if condition in object level filter in NPrinting.

trying to add below one but getting 0 values in Objects.

if(num(field1))=1,num(max(field1)),num(max(field2))

request to please help me on this.

thanks in advance.

 

 

 

Labels (1)
5 Replies
FedericoDellAcqua

llo @bhaskar1986 , if you already defined your object in Sense that way (with your filter application), and put it in a Nprinting project, then it will be printed like you wanted to. 

Otherwise (if the graphs are now different)  my suggestion is to prepare the graph in Sense to have the filter you like in your dimension and then give it to Nprinting, it's way easier! 

bhaskar1986
Contributor II
Contributor II
Author

Qliksense application has last two years data so need to fetch max data in nprinting.

Due to that we can't apply same filters.

FedericoDellAcqua

@bhaskar1986 so why not create an object in sense which already filters your Data dimension like "if(Data=MaxData, Data, null())" excluding the null values for the dimension.
you could have inside the application an object that shows only what you need, and then you could insert it into the Nprinting report.

bhaskar1986
Contributor II
Contributor II
Author

we are not able to change existing objects , its effects other KPI 

so need to apply same filter in NPrinting.

if(getselectedcount(field1)=1,max(field1),max(field2)

 

bhaskar1986
Contributor II
Contributor II
Author

how to write below expression in NPrinting filters as default filter in qliksense app

if(getselectedcount(field1)=1,max(field1),max(field2))

thanks in advance