Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression value ......


I have a table with 2 dimensions plant and material.

Plant has values FBPL, FCHI, F003, F005....

PlantMaterialF003F005
FBPLABC
FCHIXYZ

Now, in F003 column I want count of stock for plant F003 and material ABC ignoring FBPL. Similarly, stock for F005 and XYZ ignoring FBPL.

Kindly help!!!

Regards,

Rajeshree

1 Reply
hic
Former Employee
Former Employee

You say that "Plant has values FBPL, FCHI, F003, F005". But this is not reflected in the table... You have some plant values as values to the left, and other plant values as column headers to the right. This doesn't make sense.

So you need to explain more what your requirements are.

HIC