Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Showing data quarterly from month data

Hi All,

PFA.

Below is the requirement.

When data for Jan,Feb ,Mar is present then make Jan+Feb+Mar for indicator value and show data for Q1 on march.

Similirly for Q2 on jun for Apr+May+jun

Q3 on sept for jul+aug+sept

And Q4 on dec for oct+Nov+Dec

If any month in any of quarter is not present then data for that quarter should not display

eg suppose for 2001  oct  is absent so Q4  that is dec for 2001 shoud not display.

I am using below fomula

=if(mod(Month(DATE),3) = 0, If(month(DATE) -1 = Month(Above(DATE)) and (month(DATE) -2) = Month(Above(Above(DATE))),

Above(Text)+Above(Above(Text))+ Sum(INDICATOR_VALUE)), Sum({<INDICATOR_NAME={'FRCOSTRT Index = France Housing Starts Total'},

MONTH={3,6,9,12}>}INDICATOR_VALUE)

)

and DATE is domension.

Req  is to show this in bar chart

1 Solution

Accepted Solutions
sunny_talwar

Does this resolve the issue?

=If(Mod(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)),3) = 0,

If(Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -1 = Month(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE))) and

  (Month(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)) -2) = Month(Above(Above(Only({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}DATE)))),

Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)) +

Above(Above(Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE))) +

Sum({<INDICATOR_NAME = {'FRCOSTRT Index = France Housing Starts Total'}>}INDICATOR_VALUE)))

Output:


Capture.PNG

View solution in original post

18 Replies
Not applicable

PFA

Not applicable

Hi,

in the script you can add this,

load *,

......

'Q' & ceil(num(month(Date))/3) as Quater_Month,

......

residant ......;

deepakqlikview_123
Specialist
Specialist
Author

Hi All,

Still it is not giving desired result.Can you please suggest on this.

Thanks

sujeetsingh
Master III
Master III

Your line as below :

If any month in any of quarter is not present then data for that quarter should not display

eg in my data data for oct 2001 is absent so Q4  that is dec for 2001 shoud not display

To achieve this you can use subpress nulls

qlikviewwizard
Master II
Master II

Hi,

Check the attached file. Hope this will help.

Thank you.

deepakqlikview_123
Specialist
Specialist
Author

Hi All,

PFA.

Below is the requirement.

When data for Jan,Feb ,Mar is present then make Jan+Feb+Mar for indicator value and show data for Q1 on march.

Similirly for Q2 on jun for Apr+May+jun

Q3 on sept for jul+aug+sept

And Q4 on dec for oct+Nov+Dec

If any month in any of quarter is not present then data for that quarter should not display

eg in my data data for oct 2001 is absent so Q4  that is dec for 2001 shoud not display.

I need to show this in bar chart, but i could not find hhe solution please suggest

qlikviewwizard
Master II
Master II

If any month in any of quarter is not present then data for that quarter won't be display.


What is Jan+Feb+Mar?

deepakqlikview_123
Specialist
Specialist
Author

Jan+Feb+Mar is for Q1 need to be show Jan+Feb+Mar entire sum on Mar. if any month in respective quarter is not present then bar for that quarter should not display

deepakqlikview_123
Specialist
Specialist
Author

All,

Can you please suggest  on this.

Thanks