Discussion Board for collaboration on QlikView Scripting.
I have tables like this :
a1, 2 ,3
b1 3 ,2
c1 4 ,1
d1 5 1
2, a1 a
3, a2 a
4, a3 a
5 b1 b
where comp_names are grouped under comp_type.
not i want to select like
comp_name1 and its rating and comp_name2 and its rating .
which should give me the employees for the selected criteria.
now i want data like
a and b as columns and the respective comp_name under those a and b columns.
Go to Solution.
See attached example.
I don't understand what you're asking. Can you post an example of what the result should look like?
Sorry but don't understood your requirements completely.
Can you elaborate little more along with your expected result?
Above are the tables where each employee will have his competency_name and its corresponding rating in different tables where they are joined using competency_id and level_id.
Now is it possible to select on competency_name wise like
PLANNING with level_value 1 and TRAINING with level_value as 2 and .NET with level_value as 3 then it should show me the employees with these competencies.
Yes, it's possible. But it's a bit tricky. It can be done using alternate states and set analysis expressions. If you can post a sample document with some data someone here can try to create a solution for you.
i have attached the sample document.
Yes i want this only.
Thank you so much.
its working ....
can we group the competeny_names under its competency type
like competencytype TECHNOLOGY WORKED WITH is column which contains all its competency names under this column.
same way SOFT SKILLS will be the column which contains its respective competency names as field values.
total there are five competency types values..so five fields should be generated.
Is this possible.
Could you please help me this scenario.