Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
faisalaaa
Contributor III
Contributor III

Set Analysis - Three Months

Hi, I would like to apply set analysis to the attached table, comparing three months, per location. Thanks

13 Replies
qlikviewwizard
Master II
Master II

MK_QSL
MVP
MVP

Where is Location in your excel file? Is that Branch?

Also, what is meant by comparing three months? Can you provide expected output in excel?

Not applicable

Hi Faisal

do you mean some thing like this,

if not please provide sample result

test.PNG

faisalaaa
Contributor III
Contributor III

JulAugSep
BR---------
HK---------
---------

Not applicable

test1.PNG

Hi Faisal

use branch & month as dimension,

then drag the month to the top of table.

Not applicable

Can you check the attach

Regards

Not applicable

Excuse the previus qvw had an error in the current month formula

Check the new attachment

teiswamsler
Partner
Partner

Hi Faisalaaa

This set analysis will dynamic present the sales for current month and last 2 month - from max selected date

Sum( {$<CalenderYear, CalenderMonth, CalenderQuater, Date = {">=$(=Floor(Addmonths(Monthstart(Max(Date)), -3 )))<=$(=Max(Date))"} >} Sales )

Ex for dimensions

Salespersonal

YearMonth

/Teis

faisalaaa
Contributor III
Contributor III

I do not have Year or Quarter nor Date.

Only Months !