Discussion board where members can get started with Qlik Sense.
I do have 2 columns in table1 as below:
so I need two different charts on statistics of Meetingx and Meetingy lets say 2 ppl Not Met ,3 ppl Met Thrice !!
I'm able to do it with a join on these two tables (Meeting_x & Meeting_Identifier) but I need join to happen on multiple columns from table 1 which also includes Meeting_y.
Any help on this ?
Thanks in advance !!
What is the expected output here that you would like to achieve?
my guess is that de value for the fields meeting x and meeting y correspond with meeting identifier? No?
employee 121 went to meeting x three times an to meeting y three times?
Yes exactly and the desired o/p would be :
on X axis : Not Met, Met Once, Met thrice
on Y axis : Count of ppl.
I have done this doing the join on Meeting X and Meeting Identifier but how about Meeting Y?
I think you need to make 'Meeting' a column, rather than a set of columns, so recut your data by loading as follows
'X' AS Meeting,
Meeting_x AS Meeting_Identifier
'Y' AS Meeting,
Meeting_y AS Meeting_Identifier
Then drop your original table1.
A neat way of achieving this is via a mapping load and then a cross table.
Refer to attachment and see if it achieves what you are after.
I have tried to comment the code to tell you my thought process.
Hope that helps!
Didn't you forget the attachement?
I always forget crosstable, being an old MS Access hacker, it means something different to me ...