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: 
cindymak821
Contributor
Contributor

Show static value one by one

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!

Labels (2)
7 Replies
tresesco
MVP
MVP

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

sugathirajkumar
Creator
Creator

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
Creator
Creator

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
Creator
Creator

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

cindymak821
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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