Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
employe4_2
Contributor III
Contributor III

TRUE FALSE spreadsheet

Hi, 

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

2019-12-19_12h03_51.png

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 2019-12-19_12h14_35.png

any hint ? 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

5 Replies
Anil_Babu_Samineni

May be

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
employe4_2
Contributor III
Contributor III
Author

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 ....

2019-12-19_12h41_20.png

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jsteyn
Creator
Creator

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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