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

How to ignore selection on a text object scripting?

jim_chan — Tue, 18 Oct 2016 22:28:15 GMT

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

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

sunny_talwar — Tue, 18 Oct 2016 22:45:11 GMT

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

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

jim_chan — Tue, 18 Oct 2016 23:01:50 GMT

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?

sunny_talwar — Tue, 18 Oct 2016 23:06:25 GMT

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

Best,

Sunny