Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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‌!