Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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