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

sbiradar — Wed, 25 Nov 2020 16:16:04 GMT

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.

Date	ID	Text1
08/12/2019	12345	ABC_123
01/12/2019	12345	ABC_123
24/11/2019	12345	ABC_123
17/11/2019	12345	ABC_123
10/11/2019	12345	ABC_123
03/11/2019	12345	ABC_123
27/10/2019	12345	ABC_DEF_123
20/10/2019	12345	ABC_DEF_123
13/10/2019	12345	ABC_DEF_123
06/10/2019	12345	ABC_DEF_123
29/09/2019	12345	ABC_DEF_123
22/09/2019	12345	ABC_DEF_123
15/09/2019	12345	ABC_DEF_123
08/09/2019	12345	ABC_DEF_123
01/09/2019	12345	ABC_DEF_123
25/08/2019	12345	ABC_DEF_123
18/08/2019	12345	ABC_DEF_123
11/08/2019	12345	ABC_DEF_123
04/08/2019	12345	ABC_DEF_123
28/07/2019	12345	ABC_DEF_123
21/07/2019	12345	ABC_DEF_GEF_123
14/07/2019	12345	ABC_DEF_GEF_123
07/07/2019	12345	ABC_DEF_GEF_123
30/06/2019	12345	ABC_DEF_GEF_123
23/06/2019	12345	ABC_DEF_GEF_123
16/06/2019	12345	ABC_DEF_GEF_123
09/06/2019	12345	ABC_DEF_GEF_123
02/06/2019	12345	ABC_DEF_GEF_123
26/05/2019	12345	ABC_DEF_GEF_123
19/05/2019	12345	ABC_DEF_GEF_123
12/05/2019	12345	ABC_DEF_GEF_123
05/05/2019	12345	ABC_DEF_GEF_123
28/04/2019	12345	ABC_DEF_GEF_123
21/04/2019	12345	ABC_DEF_GEF_123
11/04/2019	12345	ABC_DEF_GEF_123
09/04/2019	12345	ABC_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.

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

Kushal_Chawda — Fri, 27 Dec 2019 11:43:10 GMT

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

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

sbiradar — Fri, 27 Dec 2019 12:15:29 GMT

Hi Kush,

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

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

Brett_Bleess — Mon, 30 Dec 2019 13:33:51 GMT

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

topic Re: Build Chart to show when value gets changed from old to new in QlikView

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

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

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

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