Crosstable issue

[Anonymous]

Hi guys,

I have 2 charts (left and right).

When I click on any tag from left chart, the results should be updated according my selection.

But it doesn't work, because use data from crosstable load.

please help me with idea how can do it?

Please find the attached file.

Thanks,

[d_pranskus · Accepted solution]

Hi

This doesn't work not because of cross table, but because you use Count function in your expression. It counts 0 values as well and because you have these for every channel and element, result does not change. Use SUM instead or replace 0 with NULL in the script. I have attached qvw with another chart "New". Please have a look

Cheers

Darius