How can I choose specific values for a Chart based on a String?

Fri, 19 Feb 2016 17:51:13 GMT

Hello,

I have a straight table where I need to list a set of values based on another field as the first dimension. I have tried multiple approaches to this and come up with nothing. Essentially my field "SC03" contains "A", "B", "C", or NULL for every record in the source table. I need the chart to only display values from my field PRODWHID where the corresponding SC03 value = "A". I have tried the following combinations:

=Aggr(SC03='A',PRODWHID) Results: NULL

=Aggr(PRODWHID,SC03='A') Results: NULL

=If(Aggr(PRODWHID,SC03)='A',PRODWHID) Results: NULL

=If(Aggr(SC03,PRODWHID)='A',PRODUCTID) Results: NULL however works with ListBox

I do not currently have any other expressions in this chart. Is there something that I am doing wrong or another parameter that I need to include?

Thank you for any help you can offer!

Re: How can I choose specific values for a Chart based on a String?

Gysbert_Wassenaar — Fri, 19 Feb 2016 17:59:58 GMT

Try with PRODWHID as dimension and Sum({<SCO3={'A'}>}1) as expression. If you want you can hide the expression on the Presentation tab of the charts properties window.

Re: How can I choose specific values for a Chart based on a String?

Fri, 19 Feb 2016 18:12:07 GMT

That got it! Now I have a place to start from. I appreciate it gwassenaar‌!

topic How can I choose specific values for a Chart based on a String? in QlikView

How can I choose specific values for a Chart based on a String?

Re: How can I choose specific values for a Chart based on a String?

Re: How can I choose specific values for a Chart based on a String?