Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
May be
Load distinct SubField(FieldName,',') as FieldName from Table....;
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 ....
My bad, Agility and "Accelerated Healing" ... are initially came into any field after load the data?
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
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