Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gowtham174
New Contributor III

Only 3 week data in line chart

Hi All,

can you please help me to get only 3 weeks data in line chart.

count({<WeekNumber={"$(=Max(WeekNumber))"}>} [Total])

Thanks,

Gowtham

1 Solution

Accepted Solutions
aarkay29
Valued Contributor

Re: Only 3 week data in line chart

Try

count({<WeekNumber={">$(=Max(WeekNumber)-3)"}>} [Total])


Make sure (Max(WeekNumber)-3) format matches the WeekNumber

1 Reply
aarkay29
Valued Contributor

Re: Only 3 week data in line chart

Try

count({<WeekNumber={">$(=Max(WeekNumber)-3)"}>} [Total])


Make sure (Max(WeekNumber)-3) format matches the WeekNumber