Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mallikagqlik
Contributor II
Contributor II

Graph comparing previous quaters with current quarters of a year

Hi,

I am fairly new to QS and not able to arrive at a sol for below issue.

I have my data like below with dimensions being Portfolio, reporting date and  segment.

Portfolioreporting_datesegmentaccount_volume
S31Aug2019S117987
S31Aug2019S219
S31Aug2019S31
S31Jul2019S129
S31Jul2019S214109
S31Jul2019S32
S30Jun2019S114
S30Jun2019S2124121
S30Jun2019S342
S31May2019S14246
S31May2019S234
S31May2019S32
S30Apr2019S132
S30Apr2019S237
S30Apr2019S32
S31Mar2019S132
S31Mar2019S237
S31Mar2019S32
S28Feb2019S1346
S28Feb2019S23
S28Feb2019S32
….……..……..…..
H31Aug2019H14364
H31Aug2019H2432
H31Aug2019H31
H31Jul2019H1324
H31Jul2019H2432
H31Jul2019H34
H30Jun2019H13
H30Jun2019H2342
H30Jun2019H342
H31May2019H125
H31May2019H234
H31May2019H32
H30Apr2019H132
H30Apr2019H237
H30Apr2019H32
H31Mar2019H132
H31Mar2019H237
H31Mar2019H32
H28Feb2019H1346
H28Feb2019H23
H28Feb2019H32

 

I select a Portfolio(H/S/….) and a reporting date ,lets say I select aug19 and S

I should see graph and data as below

 

Aug-18

Nov-18

Feb-19

May-19

Aug-19

 

Accounts

148277

150958

351

4282

18007

 

Change

#N/A

0.01808

0.0115

0.01966

0.01368

 

and a combo graph plotting the both volume and change. (The %change formula in the example is probably not correct. I meant (previous value -current value)/previousvalue.

Can some one pls help

1 Solution

Accepted Solutions
sunny_talwar

Something like attached

View solution in original post

14 Replies
sunny_talwar

When you select Aug19, why are you seeing May-19, but not Jun-19, Jul-19 as well?

mallikagqlik
Contributor II
Contributor II
Author

I used Excel =EOMONTH(P5,-3) to bring about that .I have no clue to add new selections based on current selection in Qlik

sunny_talwar

Are you looking to get 3 months back from selected date and go back as far as 1 year back?

sunny_talwar

Something like attached

mallikagqlik
Contributor II
Contributor II
Author

Yes.. From the selected date, I want to go back 3 months till an year

Is there a attachment to ur message. I am not able to get it.

sunny_talwar

You don't see the qvf attachment?

image.png

mallikagqlik
Contributor II
Contributor II
Author

Sorry Sunny , but I donot see it.

sunny_talwar

I am not sure how to help you with that... may be @Brett_Bleess might have a suggestion here.

Brett_Bleess
Former Employee
Former Employee

Hey guys, I am not much of a Sense resource, will see if I can have one of the better development related folks have a look at things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.