Set Analysis: Combo chart is not matching table

[ecak2105]

Hi guys,

I am currently facing some problems in set analysis.
The goal is to count the number of distinct IDs for works that start with '0' in the  Werk_EM

The original attempt used set analysis with the following syntax:

count({
  $<
    Werk_EM = {"$(=Index(Werk_EM, '0') = 1)"}
  > 
} distinct ID)

I want to count all the works that start with '0' and select them in a combo chart (line + bar chart). Afterwards, my table should automatically adapt to the filter that was selected in the chart. However, nothing happens in the table and the filter windows that I added do not apply to the selection that was described in the syntax.

Additionally, the combo chart disappears and only a line chart is displayed.

Could you help me out?

Thanks a lot!

[vikasmahajan]

Hi,

in script you can create flag like 

if ( Werk_EM  = 0 ,1,0) as  Werk_EM_Flag,

in set analysis:

=count({$<Werk_EM_Flag  = {">0"}>} distinct Werk_EM)

Vikas

[tresesco · Accepted solution]

To make the search string work, remove dollar and try like:

count({
  $<
    Werk_EM = {"=Index(Werk_EM, '0') = 1"}
  > 
} distinct ID)

Or, simply

count({ $<Werk_EM = {"0*"}>} distinct ID)