TRUE FALSE spreadsheet

[employe4_2]

Hi, 

I'm trying to exploit a super hero dataset with a spreadsheet looking like this : 

i created an other table with 1 column"hero_powers" to list all the powers : the colums after "hero_names"

i'm trying to visualize the number of powers and their name  for each superhero. 

But i can't figure out how i should do it. Never exploited True false table.

I tried to set up an " if " condition like : if( hero_power='True', 1)  but hero_power dimensions and 'true/flase' measure are not connected and can't understand why  since i creat that table 

any hint ? 

[Anil_Babu_Samineni]

May be

Load distinct SubField(FieldName,',') as FieldName from Table....;

[employe4_2]

Subfield function is to separate strings with commun separator. I have none. my table "hero powers" look like this in qlik, already well separated. and each super power is a variable. And i want to know : for each superhero, know every power he has. 

So i have a table with a field : heroNames and  i need to create a field wich list all powers that heros might have.

with 3 differents powers i could do : if ( Agility=true, 'Agility") and if (Accelerated Healing='true', 'Accelerated healing )

But i need to do that for 200 fields ....

[Anil_Babu_Samineni]

My bad, Agility and "Accelerated Healing" ... are initially came into any field after load the data?

[jsteyn]

Hi, here's my suggestion

You will need to normalize your dataset and only load "powers" where true(or Alternatively exclude them through set analysis)

Having 2 Tables namely: Heroes & Powers where the key would be the"Hero Name".

Once the Data model is set up creating the required visualizations should be simpler.

Hope this helps 

[rwunderlich · Accepted solution]

GENERIC Load * FROM yourfile.csv;

I meant :

CrossTable (Skill, HasSkill, 1)
LOAD * FROM yourfile.csv;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com