Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jim_chan
Contributor III

How to ignore selection on a text object scripting?

Hi guys,

I have a line of codes. I need to add this into a text object to display the total records. Problem is when i selected any of the filters, it changed.

what else to change in this code so that wont be affected by filters. ?

=(count({$<number = {'$(=max(number))'}, year = {'$(=max(year))'},likelihood_name={LOW},impact_name={LOW},status={DELETED}>} number) )

+

(Count(DISTINCT {<record_id = e({<record_id = {"=Count({<year = {'<$(=Max(year))'}>} record_id ) > 0"}>}), likelihood_name = {'LOW'},impact_name = {'LOW'}>} record_id ))




rgds

Jim

3 Replies

Re: How to ignore selection on a text object scripting?

May be this:

=(Count({1<number = {'$(=Max({1}number))'}, year = {'$(=Max({1}year))'},likelihood_name={LOW},impact_name={LOW},status={DELETED}>} number) )

+

(Count(DISTINCT {1<record_id = e({1<record_id = {"=Count({1<year = {'<$(=Max({1}year))'}>} record_id ) > 0"}>}), likelihood_name = {'LOW'}, impact_name = {'LOW'}>} record_id))

jim_chan
Contributor III

Re: How to ignore selection on a text object scripting?

Bro,

The figure goes wrong when added 1.

(Count(DISTINCT {1<record_id = e({1<record_id = {"=Count({1<year = {'<$(=Max({1}year))'}>} record_id ) > 0"}>}), likelihood_name = {'LOW'}, impact_name = {'LOW'}>} record_id))


Rgds,

Jim

Re: How to ignore selection on a text object scripting?

‌Really? I would have not expected that. Can you provide a sample of screenshots of what you are seeing?

Best,

Sunny

Community Browser