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: 
nareshthavidishetty
Creator III
Creator III

Filter selection won't reflect objects

Hi,

Am having a requirement like the filter selection wont effect the value inside the text object like if the user selects an month the text object won't reflect

13 Replies
sunny_talwar

Maybe you need {1} in the denominator expression as well:

=Num(Count({1<[ApplicationStatus] ={'Approved'},FiscalYear={'2016-2017'}>} DISTINCT ApplicationNbr)/Count(DISTINCT({1} ApplicationNbr)), '##.00%')

nareshthavidishetty
Creator III
Creator III
Author

Hi,

For below expressions,

=Count( Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApp_Date))

Below logic is't working ,

if(FiscalYear='2016-2017',Count(Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApplication_Date)))

sunny_talwar

It seems you are just adding new requirements to the existing post. Can you please create new threads for new requirements and close this one my marking correct and helpful answers?

nareshthavidishetty
Creator III
Creator III
Author

Hi,

The below expression is for same issue,

=Count( Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApp_Date))


Thanks..