Dynamic Column Content

Mon, 28 Nov 2011 23:07:47 GMT

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

Re: Dynamic Column Content

johnw — Mon, 28 Nov 2011 23:33:37 GMT

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.

Dynamic Column Content

Wed, 30 Nov 2011 00:10:59 GMT

Hi John,

Thank you very much it works well 🙂

Best regards,

Alex

topic Dynamic Column Content in QlikView

Dynamic Column Content

Re: Dynamic Column Content

Dynamic Column Content