How to show the respective fields in cross table

[Anonymous]

I'm new to Qlikview and I've got a question about the use of fields from an inline load.

Selected field in the Group only should show in the cross table.

See attached

[sunny_talwar · Accepted solution]

Is this what you want?

No selection

With one selected

With 2 selected

I added a conditional expression for the three expressions you have

Expression

=SubStringCount(Concat(DISTINCT '|' & Group & '|'), 'Head1')

=SubStringCount(Concat(DISTINCT '|' & Group & '|'), 'Head2')

=SubStringCount(Concat(DISTINCT '|' & Group & '|'), 'Head3')

Not sure if this is what you wanted, but that's what I thought you wanted. If this is not what you wanted, you can clarify and we would be more than happy help you.

Best,

Sunny