Solved: Group Skills by Column - Qlik Community

tracycrown · ‎2015-01-27

Dear all

I have tried many times this morning but failed to make it work. Kindly advise the followings asap :

Q1 : How to display only those members who have not paid membership fee (ie amount=$0.00) ?

Q2 : How to group skills in column form by employee ?

The expected answer is shown in Excel Worksheet called "Answer".

Thank You Very Much

Tracy

Anonymous · ‎2015-01-27

Hello,

PFA .

For Q2, I am looping through the counts of each skill by name. I used concat to get all the counts in the order of names into a variable.

That's it. look into 'for each' in the help, if you have any doubts . Look into the script. I have left some comments in there.

HTH.

robert_mika · ‎2015-01-27

If your data are coming from Excel file would not be easier to split the skills to separated columns in Excel?

Anonymous · ‎2015-01-27

Hello,

PFA

HTH

tracycrown · ‎2015-01-27

Dear Ravichandra Nadiminti

Many thanks for helping me on Q2, can you explain how the script works step by step as I don't understand at all.

How about Q1, I only want to display those with zero amount. Please help.

Thank you vey much

Tracy

tracycrown · ‎2015-01-27

Dear Robert

The current database already has few thousand records, it will be difficult to split them manually now in Excel.

Regards

Tracy

Anonymous · ‎2015-01-27

Hello,

PFA .

For Q2, I am looping through the counts of each skill by name. I used concat to get all the counts in the order of names into a variable.

That's it. look into 'for each' in the help, if you have any doubts . Look into the script. I have left some comments in there.

HTH.