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: 
jim_chan
Specialist
Specialist

How to track records that have changes in some columns.

Hi guys,

I have posted up this question b4. but no answer yet.

For example . i have 2 years of data loaded in. 2015-2016.

Take ID 003 as example: in year 2015, category column is charlie and locatin column is shop

in year 2016, ID 003, category changes to delta and location change to Toilet.

I need a text object to count all these ID that has changed. and a table box that show which ID has changes in category and location column.

screenshots.jpg

1 Solution

Accepted Solutions
sunny_talwar

Front end solution

Text box expression:

=Count(DISTINCT {<Record_ID = {"=Count(DISTINCT Category&Location) > 1"}>} Record_ID)

Straight table (instead of table box)

Dimensions

Record_ID

Year

Status

Rating

Location

Category

Expression

=If(Year = 2016, Count(DISTINCT {<Record_ID = {"=Count(DISTINCT Category&Location) > 1"}>} Record_ID))

Capture.PNG

View solution in original post

31 Replies
shraddha_g
Partner - Master III
Partner - Master III

do u have last update date for the records?

jim_chan
Specialist
Specialist
Author

Hi there,

this is my exmaple.

rgds,

Jim

Anonymous
Not applicable

Do you have to have a textbox to display the number of records that have changed or can you just flag or list the changes in a straight table?

Check the attached.

Hopefully this helps you.

jim_chan
Specialist
Specialist
Author

In my orignal data, there's one last update column.  what should i do with that?

Anonymous
Not applicable

Hi Jim,

Try this one

sunny_talwar

Jim -

Didn't we already work on something similar to this in the past?

Best,

Sunny

jim_chan
Specialist
Specialist
Author

no bro... i am waiting for you!!!  come, lets back to the post. we left this one.

sunny_talwar

How many do you expect to see as the output?

jim_chan
Specialist
Specialist
Author

1 text object to display the count.

1 table box object to display the record id that has changes in cloumns compare to previous year.