Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted

Re: Filter selection won't reflect objects

Add {1} in your expression.

=Count( {1} ItemName)

View solution in original post

13 Replies
Highlighted

Re: Filter selection won't reflect objects

Restrict the text box expression using set analysis:

{<Month =, OtherFields = >}

Highlighted

Re: Filter selection won't reflect objects

Add {1} in your expression.

=Count( {1} ItemName)

View solution in original post

Highlighted
Champion III
Champion III

Re: Filter selection won't reflect objects

please share the sample qvw?

did u given that  value in textobj as

=urfield()

Highlighted
Specialist III
Specialist III

Re: Filter selection won't reflect objects

Use set analysis.

Take a look at https://community.qlik.com/docs/DOC-4951

Your expression in text object should have an identifier  {1}

For example:

Sum({1} [Sales]) : sum of everything (All dimensions are completly reset to All).

Highlighted
Master III
Master III

Re: Filter selection won't reflect objects

Naresh,

Like this???

Thanks,

AS

Highlighted
Creator III
Creator III

Re: Filter selection won't reflect objects

Hi,

This logic =Count( {1} ItemName) won't work for the below logic


=Count({1}{<Channel = {'In-store'}>} DISTINCT ApplicationNbr)

Highlighted

Re: Filter selection won't reflect objects

It should, you just need to fix the position of your 1

=Count({1<Channel = {'In-store'}>} DISTINCT ApplicationNbr)

Highlighted

Re: Filter selection won't reflect objects

Sunny has corrected your expression. Always try to provide some example, so that we can help you better.

Highlighted
Creator III
Creator III

Re: Filter selection won't reflect objects

Hi

Below expression wouldn't work mens it reflects to selection

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