Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

LOAD specific cell according to its value from excel

Hi

I have a column in excel sheet that contains random values from the set {A, B, C, D, E}.
I want to plot each value (A, B, ...,etc.) as a single line in line chart. How can I do that using script?

6 Replies
awhitfield
Esteemed Contributor

Re: LOAD specific cell according to its value from excel

Hi Adnan,

could you expand your requirement please? Maybe supply an example data source file and a mock up of you expected output?

Thanks

Andy

Not applicable

Re: LOAD specific cell according to its value from excel

Hey Andrew

In the attached photo you can find two columns; one for quality grade and the other is for the year.
I want to plot each quality grade (a, b, c ...) as a single line in line chart progressing over time.
In this case I would get one line chart; dimension is "Date" and measure is "Test Quality" with a line for each grade (a, b, c ...).

reddys310
Honored Contributor II

Re: LOAD specific cell according to its value from excel

Hi Adnan,

Yes its possible.

In this case you need to do something similar to this:

Check this out:

Capture.PNG

Thanks,

Sangram Reddy

reddys310
Honored Contributor II

Re: LOAD specific cell according to its value from excel

Sample File!

Not applicable

Re: LOAD specific cell according to its value from excel

Thanks Sangram

But, according to my attached photo, what I actually want is plotting each quality grade in a single line in the chart. That is: a line for grade 'a', a line for 'b', a line for 'c', ...., etc.

PIC.jpg

undergrinder
Valued Contributor II

Re: LOAD specific cell according to its value from excel

Hi Adnan,

Try this:

Table:

Load

     if(Test_quality='a',measure,0) as a

    ,if(Test_quality='b',measure,0) as b

    ,if(Test_quality='c',measure,0) as c

From [YourFile];


G.