topic Re: Crosstable issue in QlikView https://community.qlik.com/t5/QlikView/Crosstable-issue/m-p/583384#M1096393 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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</P><P></P><P>Cheers</P><P>Darius</P></BODY></HTML> Wed, 30 Apr 2014 18:32:13 GMT d_pranskus 2014-04-30T18:32:13Z Crosstable issue https://community.qlik.com/t5/QlikView/Crosstable-issue/m-p/583383#M1096392 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have 2 charts (left and right).</P><P>When I click on any tag from left chart, the results should be updated according my selection.</P><P>But it doesn't work, because use data from crosstable load.</P><P>please help me with idea how can do it?</P><P>Please find the attached file.</P><P>Thanks,</P></BODY></HTML> Wed, 30 Apr 2014 18:01:45 GMT https://community.qlik.com/t5/QlikView/Crosstable-issue/m-p/583383#M1096392 Anonymous 2014-04-30T18:01:45Z Re: Crosstable issue https://community.qlik.com/t5/QlikView/Crosstable-issue/m-p/583384#M1096393 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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</P><P></P><P>Cheers</P><P>Darius</P></BODY></HTML> Wed, 30 Apr 2014 18:32:13 GMT https://community.qlik.com/t5/QlikView/Crosstable-issue/m-p/583384#M1096393 d_pranskus 2014-04-30T18:32:13Z