Need to create Two dimension fields from data set fields

[Gowtham174]

Hi All,

I need to create two dimension and those dimension should link with my data set. In my data set its 0, or 1 information in each of the fields

Test:

CrossTable([Category],[Category values],4)

LOAD

    ID,

    Field1,

    Field2,

    Field3,

    Field4,

    Field5,

    Field6

FROM [lib://Test/Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

I tried with

CrossTable([Category],[Category values],4)

Output:

Category ,Sum(Category values)

Field4 ,1

Field5,1

Field6,4

I need to show this in Bar Graph and when I select Field4, or 5,or 6 in bar graph this should link with other fields value. i.e

I created KPI for Field 1 and based on field selection in bar graph kip values should change accordingly.

Also i need to create one more dimension filed i.e for

Field2,

Field3,

Field4,

How can I create this dimension field also linking with other fields. similar bar graph I need to create. Attached my sample qvf file for reference.

Thanks,

Gowtham

[Gowtham174]

Can anyone help me on this please.

[Gowtham174]

can you please suggest on this

[nasirsaikh]

Hi Gowtham

You don't need to create dimension in script,in qlik sense you can create multiple dimensions or measures and all dimensions will link to all the tables based on the synthetic key. Below is the screenshot for creation of dimension for your reference

[Gowtham174]

I don't wan't drill down I want to create fields names as dimensions in and link with my data set

[nasirsaikh]

Can you share the script please what you have written in backend

[Gowtham174]

I already shared the QVF file, Please look into it