Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sbiradar
Contributor
Contributor

Build Chart to show when value gets changed from old to new

 

Hi ALL

I am facing challenge in building chart to show  below  with reference the sample data shown below.

1. Dates as dimension when Value of Text1 changed for each ID.

E.g.  For ID - 12345, Text1 value changed from 'ABC_DEF_GEF_123' to 'ABC_DEF_123' on 28/07/2019 and from 'ABC_DEF_123' to 'ABC_123' on 03/11/2019.

I want to these dates in dimension and Text1 values to highlight the changed values.

2. How to show this changes for all IDs from my dataset like for one ID above.

Please refer sample dataset.

DateIDText1
08/12/201912345ABC_123
01/12/201912345ABC_123
24/11/201912345ABC_123
17/11/201912345ABC_123
10/11/201912345ABC_123
03/11/201912345ABC_123
27/10/201912345ABC_DEF_123
20/10/201912345ABC_DEF_123
13/10/201912345ABC_DEF_123
06/10/201912345ABC_DEF_123
29/09/201912345ABC_DEF_123
22/09/201912345ABC_DEF_123
15/09/201912345ABC_DEF_123
08/09/201912345ABC_DEF_123
01/09/201912345ABC_DEF_123
25/08/201912345ABC_DEF_123
18/08/201912345ABC_DEF_123
11/08/201912345ABC_DEF_123
04/08/201912345ABC_DEF_123
28/07/201912345ABC_DEF_123
21/07/201912345ABC_DEF_GEF_123
14/07/201912345ABC_DEF_GEF_123
07/07/201912345ABC_DEF_GEF_123
30/06/201912345ABC_DEF_GEF_123
23/06/201912345ABC_DEF_GEF_123
16/06/201912345ABC_DEF_GEF_123
09/06/201912345ABC_DEF_GEF_123
02/06/201912345ABC_DEF_GEF_123
26/05/201912345ABC_DEF_GEF_123
19/05/201912345ABC_DEF_GEF_123
12/05/201912345ABC_DEF_GEF_123
05/05/201912345ABC_DEF_GEF_123
28/04/201912345ABC_DEF_GEF_123
21/04/201912345ABC_DEF_GEF_123
11/04/201912345ABC_DEF_GEF_123
09/04/201912345ABC_DEF_GEF_123

 

I Have tried using Previous function to compare each row value and flag for row where value gets changed , but I am not getting expected output from this.

 

Thank you in advance.

3 Replies
Kushal_Chawda

can you draw rough chart so that we will get some idea how you want to look at it

sbiradar
Contributor
Contributor
Author

Hi Kush,

I am not able to get an idea which chart is suitable to show this.

Brett_Bleess
Former Employee
Former Employee

Best I can offer on this one is the Design Blog area base URL, there are hundreds of how-to related posts from our experts there, not sure if you will find something to inspire you or not, but that is where I would start on this one...

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.