topic Re: Filter selection won't reflect objects in QlikView

Filter selection won't reflect objects

nareshthavidishetty — Wed, 24 Feb 2016 09:38:45 GMT

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

Re: Filter selection won't reflect objects

sunny_talwar — Wed, 24 Feb 2016 09:40:45 GMT

Restrict the text box expression using set analysis:

{<Month =, OtherFields = >}

Re: Filter selection won't reflect objects

tamilarasu — Wed, 24 Feb 2016 09:40:46 GMT

Add {1} in your expression.

=Count( {1} ItemName)

Re: Filter selection won't reflect objects

Chanty4u — Wed, 24 Feb 2016 09:41:03 GMT

please share the sample qvw?

did u given that value in textobj as

=urfield()

Re: Filter selection won't reflect objects

MindaugasBacius — Wed, 24 Feb 2016 09:42:06 GMT

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).

Re: Filter selection won't reflect objects

amit_saini — Wed, 24 Feb 2016 09:42:19 GMT

Naresh,

Like this???

Thanks,

Re: Filter selection won't reflect objects

nareshthavidishetty — Wed, 24 Feb 2016 09:48:13 GMT

Hi,

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

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

Re: Filter selection won't reflect objects

sunny_talwar — Wed, 24 Feb 2016 09:49:45 GMT

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

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

Re: Filter selection won't reflect objects

tamilarasu — Wed, 24 Feb 2016 09:57:10 GMT

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

Re: Filter selection won't reflect objects

nareshthavidishetty — Wed, 24 Feb 2016 13:33:53 GMT

Below expression wouldn't work mens it reflects to selection

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

Re: Filter selection won't reflect objects

sunny_talwar — Wed, 24 Feb 2016 13:35:55 GMT

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%')

Re: Filter selection won't reflect objects

nareshthavidishetty — Wed, 24 Feb 2016 14:54:41 GMT

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)))

Re: Filter selection won't reflect objects

sunny_talwar — Wed, 24 Feb 2016 14:56:47 GMT

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?

Re: Filter selection won't reflect objects

nareshthavidishetty — Wed, 24 Feb 2016 15:17:12 GMT

Hi,

The below expression is for same issue,

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

Thanks..