Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me.
I am beginner so, i need your help please

| Ceritification Table | Name Table | I want to create table or pivot in qlik | ||||||||
| Name | Position | Certification | Name | Determine how many certification by Name as like count-ifs in Excel | ||||||
| A | C | A | 0 | 1 | >2 | >3 | ||||
| A | PG | Y | B | 1 | 3 | 3 | 2 | |||
| A | SG | Y | C | |||||||
| B | SF | Y | D | |||||||
| B | PF | Y | E | |||||||
| B | C | Y | F | |||||||
| B | PG | G | ||||||||
| B | SG | Y | H | |||||||
| C | PG | Y | I | |||||||
| C | SG | Y | ||||||||
| D | SF | Y | ||||||||
| D | PF | Y | ||||||||
| F | C | Y | ||||||||
| G | PG | Y | ||||||||
| H | PG | Y | ||||||||
| H | SG | Y | ||||||||
| H | C | Y | ||||||||
| H | SF | |||||||||
| I | SF | Y | ||||||||
| I | PF | |||||||||
Thank you for your reply !! ![]()
Sorry to late for my late reply ![]()
Hi Sunny,
I hadn't clicked on the advanced editor before...
Please find sample QVF
Cheers
Luis