Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

current to future only

Hai all,

Tresesco B

i have data like  region quarter    value, is there    below is my requirment

Req :  the pivot table should show the  result for  from current quarter to till futer quarters avaiable in data

means:  current quarter 2018Q4   to - 2030Q3  (   old quarters data should not sum /count in the result table)

Thanks

Sony

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: current to future only

sorry forgot one equal sign

see attached

View solution in original post

28 Replies
Highlighted
Master II
Master II

Re: current to future only

exp1:

count({<Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3)"}>}deal)

exp2:

sum({<Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3)"}>}Value)

Highlighted
Master II
Master II

Re: current to future only

What else do you expect to get a correct answer instead a helpful one?

Highlighted
Specialist III
Specialist III

Re: current to future only

thank you  sir its working ..franky_h79

but if i want to add one measure  which  is

metric: service mix % =  services/totalvalue

how can i do this?  services is type  i want  servicemix% for only service not for hardware.

i want the result shown in image,

Highlighted
Master II
Master II

Re: current to future only

see attached

Highlighted
Specialist III
Specialist III

Re: current to future only

thank you  its showing as i expected but i want to show  number of deals also  if you can see screen shot.  its there 

Highlighted
Master II
Master II

Re: current to future only

updated qvw, see attached

Highlighted
Specialist III
Specialist III

Re: current to future only

sorry i got it  i added number of deals thank you

one last doubt -

this is for  current and next all future quarters   :count({<Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3)"}>}deal)

in same way i want the expression for   current and next3  (for ex:- 2018Q4,2019Q1,2019Q2,2019Q3 ) quarters how can i write in set analysis ?

Highlighted
Master II
Master II

Re: current to future only

see attached

Highlighted
Master II
Master II

Re: current to future only

sorry forgot one equal sign

see attached

View solution in original post