Discussion board where members can get started with QlikView.
I have data set as attached below.
I want to create a chart which shows count of customer id who are in current month as well as previous month( i.e. the common customer id count). The chart is like shown below.
Try the following code:
AutoNumber(Month) As Month_ID
[..\Downloads\New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Sheet1) ;
if(peek('Customer Id')=[Customer Id] and peek('Month_ID')=Month_ID-1,1,0) as Flag
Resident Tab1 order by [Customer Id] ,Month_ID asc;
DROP Table Tab1;
View solution in original post
Any idea of doing this from front end and not backend scripting?