topic Re: Group Skills by Column in QlikView

Group Skills by Column

tracycrown — Tue, 27 Jan 2015 07:45:27 GMT

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

robert_mika — Tue, 27 Jan 2015 08:22:49 GMT

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

Anonymous — Tue, 27 Jan 2015 10:48:30 GMT

Hello,

PFA

HTH

tracycrown — Tue, 27 Jan 2015 15:00:22 GMT

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 — Tue, 27 Jan 2015 23:14:47 GMT

Dear Robert

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

Regards

Tracy

Anonymous — Wed, 28 Jan 2015 04:54:02 GMT

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.