Solved: Dynamic Column Content - Qlik Community

Report Inappropriate Content · ‎2011-11-28

Hi All,

I have loaded two excel files into QV

1st excel file PN.xls has three columns: PartNumber, Country, FormFactor

2nd excel file Warranty.xls has four columns: PartNumber, German_Warranty, UK_Warranty, France_Warranty

I have created MultiBox where I can select PartNumber, Country, FormFactor

My Problem:

I would like to display in a TableBox or Chart (Straight Table)

PartNumber, Country, FormFactor, Warranty

How can I populate Warranty column according to the country that was selected

and leave blank in no country was selected.

Something like if Country='DE' then Warranty column is populated with German_Warranty

if no country is selected then Warranty columns is blank.

Thanks in advance.

Best Regards,

Alex

johnw · ‎2011-11-28

Consider using a crosstable load to convert your warranty columns into rows:

CROSSTABLE (Country, Warranty)
LOAD
PartNumber
,German_Warranty as DE
,UK_Warranty as UK
,France_Warranty as FR
FROM Warranty.xls

Now you should get the right Warranty value depending on Country selections without having to do anything special in the front end objects. In this specific case, it will also product a synthetic key on PartNumber and Country, but I don't consider that a problem.

View solution in original post

johnw · ‎2011-11-28

Consider using a crosstable load to convert your warranty columns into rows:

CROSSTABLE (Country, Warranty)
LOAD
PartNumber
,German_Warranty as DE
,UK_Warranty as UK
,France_Warranty as FR
FROM Warranty.xls

Now you should get the right Warranty value depending on Country selections without having to do anything special in the front end objects. In this specific case, it will also product a synthetic key on PartNumber and Country, but I don't consider that a problem.

Report Inappropriate Content · ‎2011-11-29

Hi John,

Thank you very much it works well 🙂

Best regards,

Alex