Pivot table shows incomplete visualization with more than 6 metrics

[Necator]

Hello,

I built a self-service visualization for users (Qlik Cloud). This consists mostly of a big pivot table with a lot of metrics and dimensions, which are all hidden by default using a show condition. In addition to the table, there are two list selectors where users can toggle each metric and dimension. This then sets the show condition to true.

This method works great and users can select the exact dimensions & metrics they want to display, creating their own pivot table in Qlik.

However, if a user selects a 7th metric, the chart switches to 'Incomplete Visualization'. This happens in every single dashboard with different data models and metrics, so I assume it's not a data size issue. Are there any other limitations that could be causing this?

Thanks in advance

[Or]

Sounds like it might be an issue with the formulas you're using for measures. If you include those, that would be helpful. 

[Necator]

The formulas mostly look like this: =$(=Only({<KPINumber = {16}>}Formel)). This selects the right formula number from the script, where it is usually defined something like: median(SALE_DURATION).

I have this kind of visualization in several dashboards with different data models and metrics. The visualization always becomes incomplete when selecting a 7th metric, regardless of which metrics are selected. So I assume the issue is not within a specific metric, but rather some kind of memory or HyperCube limit of pivot tables. I tried this with a straight table as well, and there it works fine.

[Or]

I have quite a few pivot tables with more than six measures, so I can't imagine this is any sort of limitation of that nature. 

I would suspect that somewhere, somehow, you are using GetFieldSelections() or a similar function, but your description doesn't mention that?

[Necator]

The visibility of each metric and dimension is controlled by the following formula in the Show Condition field:

if(wildmatch(GetFieldSelections(KPI), '*$(=Only({<KPINumber = {16}>}KPI))*'),1,0)

[Or · Accepted solution]

Makes sense - the number seven in particular was a strong clue.

GetFieldSelections ( field_name [, value_sep [, max_values [, state_name]]])

max_values

The maximum number of field values to be individually listed. When a larger number of values is selected, the format 'x of y values' will be used instead. The default is 6.

So, there's your problem, and luckily it's an easy fix - just add the max_values parameter to your GetFieldSelections(). 

[Necator]

Great thanks, that worked.