topic Re: Text box and pivot table expressions in QlikView

Text box and pivot table expressions

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

Hi all,

I am using this expression

=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {$(=Max(Week_UP))}>}Orders)

which is working fine in text box but its not working in pivot table.

Regards,

Joshua.

Re: Text box and pivot table expressions

vikasmahajan — Thu, 16 Jun 2016 06:06:18 GMT

What is a dimension , attached some sample qvw

Vikas

Re: Text box and pivot table expressions

avinashelite — Thu, 16 Jun 2016 06:14:08 GMT

Text box doesn't consider the dimension and its totally dependent on your selection , expression but in the Pivot table expression are totally dependent on the dimensions your using . check your pivot table dimensions once

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 06:24:35 GMT

Hi PFA

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 06:26:34 GMT

Hi avinashelite vikasmahajan

PFA .

I am getting wromg answers in pivot

Re: Text box and pivot table expressions

avinashelite — Thu, 16 Jun 2016 06:29:18 GMT

could you please share the dimensions your using , currently i don't have the QV licence. You could share the snapshots of your dimension and expression

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 06:33:46 GMT

'avinashelite

Re: Text box and pivot table expressions

avinashelite — Thu, 16 Jun 2016 06:40:20 GMT

Are you using any accumulation in Pivot table??

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 06:46:03 GMT

Hi avinashelite

No bro

Re: Text box and pivot table expressions

er_mohit — Thu, 16 Jun 2016 06:54:22 GMT

Try this

=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {"=$(=Max(Week_UP))"}>}Orders)

Re: Text box and pivot table expressions

Kushal_Chawda — Thu, 16 Jun 2016 07:00:46 GMT

try this

=sum(aggr(sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {$(=Max(Week_UP))}>}Orders),LTIM))

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 07:07:51 GMT

Hi er.mohit

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 07:10:37 GMT

Hi kush141087

Bro For week_UP 9 it showing orders for week 10 ,it should start from week 9 to week 20.

from week_up 10 its ok

for week_UP 8 or Week_Up 7 its not giving values

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 07:15:39 GMT

Hi Mohit Sharma

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 07:41:23 GMT

Hi Mohit Sharma

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

Text box and pivot table expressions

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 07:41:59 GMT

Hi Mohit,

Bro somewhat we r close to the answer but if we check for week_UP 8 or Week_Up 7 its not giving values

Text box and pivot table expressions

Re: Text box and pivot table expressions

sasikanth — Thu, 16 Jun 2016 08:06:59 GMT

hi,

try this exp in chart

=sum({<Year_UP = {'$(=Max(Year_UP))'},Week_UP = {'$(=Max(Week_UP)-8)'},Week = {'$(=Max(Week_UP))'}>}Orders)

included single quotes

also use weekyear in place of Week_UP like WeekYear = {'$(=Max(WeekYear )-8)'} ,

bcz the week number going into previous year

PFA

Re: Text box and pivot table expressions

vikasmahajan — Thu, 16 Jun 2016 08:10:38 GMT

It seems there is some data missing or some problem with LITM dimension if we remove the same you are getting results.

Vikas

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 08:16:48 GMT

Hi vikasmahajan

Bro actually if user select week_UP 8 in Year=2016 it should show orders value for week 8 which has been forecasted on 52 week of year 2015 .

Regards,

Joshua.

Re: Text box and pivot table expressions

ajsjoshua — Thu, 16 Jun 2016 08:22:50 GMT

Hi sasikanth_narne

Bro i am not getting the answer.