Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Champion
Partner - Champion

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
Author

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 ...).

reddy-s
Master II
Master II

Hi Adnan,

Yes its possible.

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

Check this out:

Capture.PNG

Thanks,

Sangram Reddy

reddy-s
Master II
Master II

Sample File!

Not applicable
Author

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
Specialist II
Specialist II

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.