Show static value one by one

[cindymak821]

Hello All,

Is there a way to show the individual values of the same field in different charts?

There are 4 values of one same field.
I would like to show the static individual value one by one using 4 charts.

Thank you very much!

[tresesco]

You can probably use set analysis for that. Could you explain your use case; may be with a sample data?

[sugathirajkumar]

A:
load * inline [
Id,Marks
1,70
2,80
3,60
4,50
5,45
];
exit Script;

chart 1:

Dim: Id

Expression : =sum({<Id={'1'}>}Marks)

chart 2:

Dim: Id

Expression : =sum({<Id={'2'}><id={'1'}>}Marks)</id={'1'}>

chart 3:

Dim: Id

Expression : =sum({<Id={'3'}><id={'2'}><id={'1'}>}Marks)</id={'1'}></id={'2'}>

so on ..

[sugathirajkumar]

A:
load * inline [
Id,Marks
1,70
2,80
3,60
4,50
5,45
];
exit Script;

chart 1:

Dim: Id

Expression : =sum({<id={'1'}>}Marks)</id={'1'}>

chart 2:

Dim: Id

Expression : =sum({<id={'2'}><id={'1'}>}Marks)</id={'1'}></id={'2'}>

chart 3:

Dim: Id

Expression : =sum({<id={'3'}><id={'2'}><id={'1'}>}Marks)</id={'1'}></id={'2'}></id={'3'}>

so on ..

[sugathirajkumar]

ignore the chart 3 some type error was there..Like chart 1 and chart 2 repeat the process.

[cindymak821]

Thank you for your reply!

So my case (OEE% of 4 pieces of equipment) is as follows:

55.1%, 55.1%,55.26%,55.26%

Looking forward to hearing from you.

Thank you again.

[cindymak821]

Thank you for your idea.

1) Where should I insert below expression?

load * inline [
Id,Marks
1,70
2,80
3,60
4,50
5,45
];
exit Script;

2) Should one measure be created for each chart?

Thanks!

[cindymak821]

Dear All,

May you please help confirm my follow-up questions?

(As I am totally new to Qlik sense..)

Your help will be highly appreciated.

Thank you again.

Best Regards,

Cindy