Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Dear All

I Am new in Qlik View.

i have to make relation between Subject and Name,

 

Name EnglishHindiMath
S1936045
S2359865
S3503995

can any on help?

thanks in advance

3 Replies

Re: Dear All

Try a crosstable load:

Table:

CrossTable(Subject, Marks)

LOAD Name,

          English,

          Hindi,

          Math

FROM Source;

Sample script for the data provided:

Table:

CrossTable(Subject, Marks)

LOAD Name,

     English,

     Hindi,

     Math

FROM

[https://community.qlik.com/thread/207960]

(html, codepage is 1252, embedded labels, table is @1);

Capture.PNG

Not applicable

Re: Dear All

Dear Sunny,

I have try the cross table concept.

i have subject in input,have to find the best in that subject.

Overall best

student Minimum and Maximum marks  and subject.

Re: Dear All

You can do this very easily by adding subject as your dimension. Check it outCapture.PNG

Community Browser