Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

sorry forgot one equal sign

see attached

View solution in original post

28 Replies
Frank_Hartmann
Master II
Master II

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
Master II
Master II

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

soniasweety
Master
Master
Author

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
Master II
Master II

see attached

soniasweety
Master
Master
Author

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
Master II
Master II

updated qvw, see attached

soniasweety
Master
Master
Author

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
Master II
Master II

see attached

Frank_Hartmann
Master II
Master II

sorry forgot one equal sign

see attached

View solution in original post