Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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