Set analysis comparison in the same table

[Sush123]

Hi team,

I need help to write a set analysis with a Trend chart for the below scenario :

Need to create a bar chart to compare data between different dates and to count no of ids which were Old, New and Changed in each date. Old/New/Changed values need to be calculated on the flow if the Code is same or changed with respect to a date. Below is the example.

Id	Date	Name	Code	Flag
10	01-06-2021	A	AU	New
11	01-06-2021	B	IN	New
12	01-06-2021	C	CN	New
13	01-06-2021	D	NZ	New
12	08-06-2021	C	CN	Old
13	08-06-2021	D	AG	Changed
14	14-06-2021	E	BP	New
11	14-06-2021	B	IP	Changed

[Ksrinivasan]

hi,

i did in exce formua

you can do it in QS by Range count function by replacing of CONCATENATE formula.

and use if function in result flag column use if function if 2=New, if 3= Change,  if 4=old.

[Sush123]

Hi @Ksrinivasan , will try this. Thanks for your help.