topic Re: total group basis problem in QlikView

total group basis problem

Wed, 25 Nov 2020 16:16:04 GMT

hi,

I need me I'll write a formula in a pivot table in expression .

thanks.

please help me

Re: total group basis problem

sunny_talwar — Thu, 15 Sep 2016 20:53:57 GMT

May be like this:

Sum(Aggr(Sum(quantity) *(Sum(time)/Sum(TOTAL <grp> quantity)), grp, Customer))

Re: total group basis problem

Thu, 15 Sep 2016 21:14:53 GMT

Thank you very much

Re: total group basis problem

sunny_talwar — Thu, 15 Sep 2016 21:18:02 GMT

Did it work? If it did, please close this thread by marking correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: total group basis problem

Fri, 23 Sep 2016 11:12:01 GMT

My friend hello,I needed help again. I had a date information in a column in this example.Can I also add the month value of the date information that pivot condition.

You have to reach a conclusion as in the following example.

required results :

Total
	month
Grp	January	February
A	18	20
B	30	22
C	20	25
D	15	28

I thank you in advance for your help.

Re: total group basis problem

Fri, 23 Sep 2016 11:55:44 GMT

my real code :

if(Dimensionality()=0,null(),

Sum(

if(lotmaster.MIKTAR>1 and not WildMatch(lotmaster.TED_LOTU,'*(*'),

if(not WildMatch(lotmaster.TED_LOTU,' *'),

Aggr(sum(lotmaster.MIKTAR) *(sum(TARIH-lotmaster.TED_LOT_URETIM_TARIH)/Sum(TOTAL <lotmaster.ISEMRI_UG> lotmaster.MIKTAR)), lotmaster.ISEMRI_UG, lotmaster.LOT_NO)

)

Re: total group basis problem

sunny_talwar — Fri, 23 Sep 2016 16:00:36 GMT

Are you sharing it with us or are you still having issues Kadir?