Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
jarrad_murray
Contributor III
Contributor III

Expression not matching with dimension in bar chart

Hi All,

I am experiencing something very strange with a bar chart.  I have one expression value that isn't joining up with a dimension but is still part of it.

image 1.png

The bar on the right hand side is the value for the 'Planned Care' dimension but is showing as not part of anything.  If I select planned care I still get the same but the value is the only one showing.

image 2.png

I don't get this issue with any of the other values I have within my data, just this one.  The expression and value are joined by a primary/foreign key relationship which is populated direct from teh table.

Does anyone have any idea what might be causing this or where I may have gone wrong?

Many thanks

Jarrad

12 Replies
vishsaggi
Champion III
Champion III

I will have to look into it again. Will get back later. ok.

vishsaggi
Champion III
Champion III

I am still looking into why $- is removing all the instances of the departmentkeys. Quiet not sure. However, for now we have a work around to use this expr in your charts. So rather than removing projects approved using $- i used condition inside the set removing -1 for those project names. Do the testing and see if that works for you. Attaching the app.

Expr used: = Count({$< Project_Name = {"= Project_Approved <> '-1'"} >} Project_Name)

I will have to further look into why that does not work. I believe we have Nulls for those department keys for whom the projects were not assigned. As the department and projects are linked based on key department key, you are finding the key 7 when you count projects.

jarrad_murray
Contributor III
Contributor III
Author

Hi Vishwarath,

Many thanks for this solution, I have applied it and it works as expected.

Thank you for all your help.

Jarrad