Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

End of Month for Current Month Last 30 day.

I have a variable-

v30Today = Date(Today()-30);

To calculate my last 30 days count I am doing this in my KPI:

count ({$<[Transaction Date] = {">=$(v30Today)"}, Month= , Year = , MonthYear= , WeekDay=>} DISTINCT  ACCOUNT_ID)

Current month is July.

I want to create a line chart that looks at Distinct count for each month. But for current month I want it to caclulate last 30 days. Is this possible?

2 Replies
andrespa
Valued Contributor

Re: End of Month for Current Month Last 30 day.

Hi Azmina, do you have your data at day level?

Not applicable

Re: End of Month for Current Month Last 30 day.

Yes I do.