Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
lalita_sharma
Contributor III
Contributor III

Compare with previous records

App IDDateFeatureFeature Onboarding Date
IN-4030Aug-21CI31/12/2020
IN-4030Jul-21CI31/12/2020
IN-4030Aug-21DL31/12/2020
IN-4030Jul-21DL31/12/2020
IN-4030Aug-21DS31/12/2021
IN-4030Jul-21DS31/12/2020
IN-4030Aug-21FC31/12/2020
IN-4030Jul-21FC31/12/2020
IN-4030Aug-21LC 31/12/2022
IN-4030Jul-21LC 31/12/2021
IN-4030Aug-21LCN31/12/2020
IN-4030Jul-21LCN31/12/2020
IN-4030Aug-21LD31/12/2022
IN-4030Jul-21LD31/12/2022
IN-4030Aug-21PONA
IN-4030Jul-21PONA
IN-4030Aug-21SFNA
IN-4030Jul-21SFNA
IN-4030Aug-21VSNA
IN-4030Jul-21VSNA

 

I have dataset which looks like above. I want to find out the Features that have different Feature Onboarding dates for August and July. For Ex.: DS and LC in above sample data and display the names of Feature in a text box.

How can I achieve this?

2 Solutions

Accepted Solutions
mato32188
Specialist
Specialist

Hi @lalita_sharma ,

try to modify your expression

Concat(DISTINCT{<[AppID] ={'IN-4030'}, Year ={'2021'}, Feature={"=Count({<[AppID] ={'IN-4030'}, Year ={'2021'}>}DISTINCT [Feature_Onboarding_Date])>1"}>}Feature,', ')

br

m

ECG line chart is the most important visualization in your life.

View solution in original post

Saravanan_Desingh

Try this,

=Concat(DISTINCT{<[AppID] ={'IN-4030'}, [Evaluation Year]={2021},Feature={"=Count({<[AppID] ={'IN-4030'}, [Evaluation Year]={2021}>}DISTINCT [Feature Onboarding Date])>1"}>}Feature,', ')

View solution in original post

8 Replies
mato32188
Specialist
Specialist

Hi @lalita_sharma ,

you can simply count unique occurrences of Feature Onboarding Date and then create flag to highlight particular Feature.

MAP_COUNT_ONBOARDING_DATES:

Mapping Load

Feature,

count(distinct [Feature Onboarding Date])

FROM xxx

group by Feature;

table:

Load

[App ID],

Feature,

Date, 

[Feature Onboarding Date],

ApplyMap('MAP_COUNT_ONBOARDING_DATES',Feature,null()) as [#Feature Onboarding Dates]

FROM xxx;

Then in text object use expression concat({<  [#Feature Onboarding Dates] = {">1"}>}distinct Feature,',').

BR

m

ECG line chart is the most important visualization in your life.
Saravanan_Desingh

Try this in a Text Box,

=Concat(DISTINCT{<Feature={"=Count(DISTINCT [Feature Onboarding Date])>1"}>}Feature,', ')
lalita_sharma
Contributor III
Contributor III
Author

Hi @mato32188 

Thanks for the solution. This would work perfect in the script. But I want to do this in the front end in a text box. Can you suggest something that will work in the front end.

 

Thanks

Lalita

lalita_sharma
Contributor III
Contributor III
Author

Hi @Saravanan_Desingh 

Thank you for the solution. This expression works perfect for the sample data set I provided above. But when I try to extend this expression to the larger dataset(attached) that has additional records for AppId's and Evaluation Year, it doesnt seem to work.

Expression I am using:   =Concat(DISTINCT{<[AppID] ={'IN-4030'}, Year ={'2021'}, Feature={"=Count(DISTINCT [Feature_Onboarding_Date])>1"}>}Feature,', ')

Out of this expression:  CI, DL, DS, FC, LC, LCN, LD

Desired Output : DS, LC

Could you please help me understand what is wrong with my expression?

Please refer to attached file for complete dataset.

mato32188
Specialist
Specialist

Hi @lalita_sharma ,

try to modify your expression

Concat(DISTINCT{<[AppID] ={'IN-4030'}, Year ={'2021'}, Feature={"=Count({<[AppID] ={'IN-4030'}, Year ={'2021'}>}DISTINCT [Feature_Onboarding_Date])>1"}>}Feature,', ')

br

m

ECG line chart is the most important visualization in your life.
Saravanan_Desingh

Try this,

=Concat(DISTINCT{<[AppID] ={'IN-4030'}, [Evaluation Year]={2021},Feature={"=Count({<[AppID] ={'IN-4030'}, [Evaluation Year]={2021}>}DISTINCT [Feature Onboarding Date])>1"}>}Feature,', ')
lalita_sharma
Contributor III
Contributor III
Author

Thanks @Saravanan_Desingh 

This works perfect!!

lalita_sharma
Contributor III
Contributor III
Author

Thanks @mato32188 

This works perfect!!