Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.
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