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: 
gauthamchilled
Creator
Creator

find missing customer ids

Hi,

I'm attaching a sample app.

My requirement is if i select particular year and see the sales in the chart, i want to see the missing customers by comparing previous year clients and show this in the chart.

Anyone pleas ehelp?

7 Replies
stabben23
Partner - Master
Partner - Master

Hi Gautham, you can simply do a pivot table instead of a straight table. Then drag and drop the Period Dimension on top.

pivot_3.GIF

gauthamchilled
Creator
Creator
Author

what i want is

in  a chart for year selected 2016,

what are the customers that exist in 2015 but not available in 2016.

stabben23
Partner - Master
Partner - Master

Ok, then you need set analysis in Your Expression, maybe like this, remove Period in Your Dimension.

Sum({<Period={$(=max(Period))}>}Sales) for selected period (2016)

Sum({<Period={$(=max(Period)-1)}>}Sales) for selected -1 period (2015)

gauthamchilled
Creator
Creator
Author

your 1st expression gives customer sales for only 2016, second expression gives for only 2015.

how can i get the customers that exist in 2015 but not available in 2016.

tresesco
MVP
MVP

Try like:

For - Present in 2015 and not in 2016 :

Sum({<CustomerId=p({<Period={'$(=max(Period)-1)'}>})>-<CustomerId=p({<Period={'$(=max(Period))'}>})>}Sales)

For - Present in 2016 and not in 2015 :

Sum({<CustomerId=p({<Period={'$(=max(Period))'}>})>-<CustomerId=p({<Period={'$(=max(Period)-1)'}>})>}Sales)

gauthamchilled
Creator
Creator
Author

hi Tresesco, 2nd expression works but not 1st one. can you please help?

tresesco
MVP
MVP

First works too. Only thing is - there are no customer ids that are present in 2015 and not in 2016, because 2016 is a super-set here in your sample. Therefore you don't get anything to see as output.