Object level filter in NPrinting

[bhaskar1986]

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.

[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]

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]

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]

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