# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## last seven days data in line chart

Hi every one i have a expression which gives me the percentage of the active customers of the total customers.I want to visualize the same for last seven days.Can any one help me what to add to the expression to make that possible.The Expression is given below.

(Count({\$<Date={'>=\$(=Date(Max(Date)-30))'},Country=P(Country),ClientStatus={0}>}distinct ClientNumber))/(Sum({\$<ClientStatus = {0}>} Aggr(RangeSum(Above(Count({1<Country=p(Country)>} Distinct Reg_ClientNumber),0,RowNo())),DataWeekNo)))

6 Replies
MVP

## Re: last seven days data in line chart

Where you trying to do this? Can you provide some context or a sample?

Not applicable

## Re: last seven days data in line chart

i am trying to make a line chart which will reflect the total number of active customers of the total number of registered members.And I want to show this for last seven days result in a single linechart

Esteemed Contributor II

## Re: last seven days data in line chart

Hi Arindam,

Create variables to replicate the below two things MaxDATE and MaxDATE-6

(Count({\$<Date={">=(MaxDATE-6)<=(MaxDATE)"},Country=P(Country),ClientStatus={0}>}distinct ClientNumber))/(Sum({\$<ClientStatus = {0}>} Aggr(RangeSum(Above(Count({1<Country=p(Country)>} Distinct Reg_ClientNumber),0,RowNo())),DataWeekNo)))

Esteemed Contributor II

## Re: last seven days data in line chart

Then you need add a calculated dimension a below

=if(Date>= maxdate-6 or date<=maxdate, Date)

And then Check Suppress when value is null

Esteemed Contributor II

## Re: last seven days data in line chart

Hi Arindam,

Have you found the solution you were looking for? or can you post a sample ?

Not applicable

## Re: last seven days data in line chart

hi Vineeth

No I have not found the solution yet .I think since I have already added date once in the set analysis I am not able to use it again to visualise the last seven days