Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel Data Dimensions on Charts

Hello QV Experts,

I have an attached excel file where a User can add a new product and choose some customisations which are applicable for this. The customisations applicable for a product are marked as X  and these may change sometime, need help in creating a report were when i select a product Table, I should see dimensions Summary, Custom2, Custom4 and Custom6 only.

Any help is appreciated.

  

ProductSummaryCustom1Custom2Custom3Custom4Custom5Custom6
Table XXXX
ChairXXXXX
CurtainsXXXXX
HandlesXXX
PanelsXXXXXX
WoodXXXX
1 Solution

Accepted Solutions
effinty2112
Master
Master

Hi,

Try:

Data:

CrossTable(Customisation,Flag)

LOAD Product,

     Custom1,

     Custom2,

     Custom3,

     Custom4,

     Custom5,

     Custom6

FROM

[Data Sample XLS.xls]

(biff, embedded labels, table is Sheet1$);

Add textboxes for Product and Customisation and test the result.

Regards

Andrew

PS you can drop the field Flag. After reload this field does nothing.

View solution in original post

4 Replies
effinty2112
Master
Master

Hi,

Try:

Data:

CrossTable(Customisation,Flag)

LOAD Product,

     Custom1,

     Custom2,

     Custom3,

     Custom4,

     Custom5,

     Custom6

FROM

[Data Sample XLS.xls]

(biff, embedded labels, table is Sheet1$);

Add textboxes for Product and Customisation and test the result.

Regards

Andrew

PS you can drop the field Flag. After reload this field does nothing.

Not applicable
Author

Cant Mark it as Correct Answer for some reason.

effinty2112
Master
Master

Never mind. It's the thought that counts.

Not applicable
Author

Hi Andrew,

Have you done something like this before?

I have a requirement where the Users can create Dynamic charts off Excel files as seen in the forums here its a standard process. However the challenge lies when some new Dimensions are introduced into the Excel file and how to update them without changing anything in Qlik. Someone suggested the below solution, but now sure if or how it works?

You could do something like add this for dimensions 1- 20

='$(vDimx)' where x = 1 to 20

the variable is defined as

=Subfield(Concat(DISTINCT $Field, ','), ',', x) where x=1 to 20

Then display $Field as a list box- maybe omit some values like those with a hide prefix.

Now you have a dynamic report builder where all you entered for the dimensions are ='(vDim1)', ='(vDim2)' and even if you add a new field to the data model it will still be available in the report builder.

Any help is appreciated.