topic current to future only in QlikView

current to future only

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: current to future only

Frank_Hartmann — Thu, 20 Sep 2018 10:18:57 GMT

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)

Re: current to future only

Frank_Hartmann — Thu, 20 Sep 2018 10:28:14 GMT

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

Re: current to future only

soniasweety — Thu, 20 Sep 2018 10:35:13 GMT

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,

Re: current to future only

Frank_Hartmann — Thu, 20 Sep 2018 11:22:15 GMT

see attached

Re: current to future only

soniasweety — Thu, 20 Sep 2018 11:25:56 GMT

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

Re: current to future only

Frank_Hartmann — Thu, 20 Sep 2018 11:26:56 GMT

updated qvw, see attached

Re: current to future only

soniasweety — Thu, 20 Sep 2018 11:31:52 GMT

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 ?

Re: current to future only

Frank_Hartmann — Thu, 20 Sep 2018 12:02:11 GMT

see attached

Re: current to future only

Frank_Hartmann — Thu, 20 Sep 2018 12:05:17 GMT

sorry forgot one equal sign

see attached

Re: current to future only

soniasweety — Thu, 20 Sep 2018 12:14:49 GMT

thank you . if i want to achieve this same as value list can i do the same ? will it work ?

because the two tables[same image for two tables] one table is currrent quarter and next 3quarters

second table will be current quarter and all future quarters .

Re: current to future only

Frank_Hartmann — Thu, 20 Sep 2018 12:21:20 GMT

not sure if i understood your requirement!

see attached

Re: current to future only

soniasweety — Thu, 20 Sep 2018 12:25:39 GMT

yes this is what i need.. because user need to see one report with current and next three quarters

one report for current and all future quarter ....

Re: current to future only

soniasweety — Fri, 21 Sep 2018 05:27:18 GMT

Hi franky_h79

Tresesco B one more thing

i want service mix column values as" %" i tried chnging from number tab but its not working bcz of value list

how to show as 38%,34%....like

Re: current to future only

tresB — Fri, 21 Sep 2018 05:54:15 GMT

PFA

Re: current to future only

soniasweety — Fri, 21 Sep 2018 06:20:07 GMT

its working in test file.. not in original file

have a look and could you please help in this file [ i dont want expression default bcz my data having millions and billions data ]

i want Number of deals -without decimal bcz its count 1450

service and hardware -- is two decimal .. 354.34

servicemix--- 38% no decimals

tresesco

Re: current to future only

tresB — Fri, 21 Sep 2018 06:34:36 GMT

sony sing wrote:

.. [ i dont want expression default bcz my data having millions and billions data ]

Have you checked if using 'expression default' really causes performance degradation?

Re: current to future only

soniasweety — Fri, 21 Sep 2018 06:37:00 GMT

if i put expression default. the milion billion format is not working only sercemix is woring and showing as 38%

tresesco

below is the result format im expecting

i want Number of deals -without decimal bcz its count 1450

service and hardware -- is two decimal .. 354.34

servicemix--- 38% no decimals

Re: current to future only

tresB — Fri, 21 Sep 2018 06:44:06 GMT

I have customized your expression for the last valuelist() member using num(), try using the same num() for other members as well with corresponding formats.

Re: current to future only

soniasweety — Fri, 21 Sep 2018 06:50:08 GMT

i have tried this still not working

num(sum({<SERVICE_TYPE={'Hardware'},Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3) and Fiscal_Period <=Year(Now()+120)&'Q' & Ceil(Month(Now()+4)/3)"}>}Value),'##.00')/$(vFormatId),