topic Re: how to keep expression result in QlikView

how to keep expression result

Anonymous — Wed, 19 Feb 2014 14:31:22 GMT

Hi, Qlikview Community

I am having a little trouble but it must be possible to solve it.

In the blue column (first pic) I have a formula:

count(DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

It purpose is to count how many job reference is in the first column (Key_CONSOL....)

It is working great but I want keep those number the same all the time.

When I select one Job reference this calculation changes (see second pic.).

I understand why that happens but can I do something that let it not happen.

Any smart ideas?

count(DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

Re: how to keep expression result

Nicole-Smith — Wed, 19 Feb 2014 14:36:52 GMT

If you only want to ignore selections in the Job Reference field:

count({<%Key_CONSOL_JOB_HEADERS=>}DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

If you want to ignore all selections:

count({1}DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

You can also give the chart a different alternate state than the rest of the document if you want to ignore all selections.

Re: how to keep expression result

datanibbler — Wed, 19 Feb 2014 14:39:53 GMT

Hi Darri,

simple: Use set_analysis - look it up in the help_file. It is a very powerful tool that can get pretty complex.

In your instance: Write

>>> Count({1} ... ) <<< - that way, the parameter 1 will cause the calculation to be performed on the entire set of records, disregarding all user_selections.

If you want to disregard most, but not all user_selections, that can be enhanced.

HTH

Best regards,

DataNibbler