topic Count Active Cols in Straight Table in QlikView

Count Active Cols in Straight Table

Brip51 — Thu, 17 Mar 2022 17:26:32 GMT

Hi,

I have a straight table and I need to capture the number of columns (both Dimensions and Measure) in the table.

The table has columns that show/hide conditionally so I need the count of all the columns that are not conditionally hidden.

I have not come up with any way to do this. I looked at NoOfColums function, but that is for pivot tables.

Any help on this would be greatly appreciated.

Thank you,

Brian

Or — Thu, 17 Mar 2022 20:27:23 GMT

You could use Dimensionality(), except specifically in the total where that wouldn't work.

Brip51 — Fri, 18 Mar 2022 12:55:33 GMT

Hi Or,

Thank you. That will give me the number of dimensions in the table. I need both dimension and expressions.

My test table has 13 total columns 2 dimensions and 11 measures. Dimensionality() correctly returns 2.

I need to count all the columns in the table.

Regards,

Brian

marcus_sommer — Tue, 22 Mar 2022 08:50:28 GMT

Why not using the show/hidden conditions to evaluate how many dimensions/expression have been set to TRUE?

- Marcus

Brip51 — Tue, 22 Mar 2022 12:54:53 GMT

Hi Marcus,

Yes. I am not sure why I didn't think of that. That worked for me. Thank you!!

Best Regards,

Brian