Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bruno_m_santos
Contributor

Like for Like calculation

Good morning,

I need your help in a calculation.

So, I need to show brands that have continuous sales in past year (if doesn't exists any period bigger than 5 days without sales)

This can be done? How?

Many thanks

Bruno

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Like for Like calculation

Hi

If you don't mind doing some calculations in the script, take a look at attached document.

5 Replies
Not applicable

Re: Like for Like calculation

Hi

If you don't mind doing some calculations in the script, take a look at attached document.

bruno_m_santos
Contributor

Re: Like for Like calculation

Hi,

many thanks by your quick answer.

Do you think, that this could be made with set analysis.

Thanks in advance

Bruno

Not applicable

Re: Like for Like calculation

Well, I wanted to do that at first but I have no clue how to even start.

But maybe it is possible

bruno_m_santos
Contributor

Re: Like for Like calculation

I've tried also (without sucess), but your solution it´s very ingenious.

bruno_m_santos
Contributor

Re: Like for Like calculation

Your tip, works fine.

Many Thanks

Bruno

Community Browser