Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You can probably use set analysis for that. Could you explain your use case; may be with a sample data?
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 ..
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 ..
ignore the chart 3 some type error was there..Like chart 1 and chart 2 repeat the process.
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.
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!
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