Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

soniasweety
Contributor 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
Frank_Hartmann
Honored Contributor

Re: current to future only

sorry forgot one equal sign

see attached

28 Replies
Frank_Hartmann
Honored Contributor

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)

Frank_Hartmann
Honored Contributor

Re: current to future only

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

soniasweety
Contributor 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,

Frank_Hartmann
Honored Contributor

Re: current to future only

see attached

soniasweety
Contributor 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 

Frank_Hartmann
Honored Contributor

Re: current to future only

updated qvw, see attached

soniasweety
Contributor 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 ?

Frank_Hartmann
Honored Contributor

Re: current to future only

see attached

Frank_Hartmann
Honored Contributor

Re: current to future only

sorry forgot one equal sign

see attached

Community Browser