Grab the current name of the dimension in a chart

[#1]

Hello Community,

I have the following problem:

I got an Excel-Table loaded into my Application where the user can enter which kinds of mistakes should be counted:

Component  Mistake1  Mistake2 Mistake3

Window        ripped       leaky          ....

....                 ...                 ....         ....

Also i got another Table where all mistakes and their kinds are registered.

What i want to do now is to create a Chart, which lists the components and counts all mistakeIDs of the Mistakes, but only the kind of mistakes entered by the user (in this case ripped, leaky for the window)

To make it a bit more clear:

If the table had only one line, this kind of formular would work:

count({<mistakes..MistakeKind ={'$(=Only(Mistake1))', '$(=Only(Mistake2))', '$(=Only(Mistake3))'} >} mistakes..ID)

So the problem is that qlikview doesn't know it should only select mistake1 for the window in the first line so the Only function runs through the whole table and returns null of course. How can i get the entry of the mistake fields only for the current dimension in the line of the chart? i know there is no function like thisdimension() or something.

Thanks for the help,

Patrick

[Gysbert_Wassenaar]

Can you post a small qlikview document that explains what you're trying to do?