topic Re: Total which does not change in QlikView

Total which does not change

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

I need to calculate the total volume of sales, by each time period and i need that value of those to not change, if the user selects a segment of the vehicle types. if i use =sum({<[TP]={$(TP1)}>} ALL Volume), where TP1 is a user entered value, I get an unchanging sum of all volumes in the data set, for all time periods, not the sum volume of all in the set of TP1. if i do this =sum(ALL{<[TP]={$(TP1)}>} Volume), the sum volume is changed, when the user clicks on a vehicle type. that is also the case with =sum({<[TP]={$(TP1)}>} TOTAL Volume) no matter when I put the word TOTAL. How do I sum the total volume of sales, for each time period, without it changing if the user selects a vehicle segment?

thanks

becki kain

Re: Total which does not change

sunny_talwar — Thu, 12 Oct 2017 15:39:41 GMT

May be this

=Sum({1<[TP]={$(TP1)}>} TOTAL <[TP]> Volume)

or this

=Sum({1} TOTAL <[TP]> Volume)

Re: Total which does not change

Anil_Babu_Samineni — Thu, 12 Oct 2017 15:40:47 GMT

Perhaps this?

Sum({1} TOTAL <[time period]> Volume)

Re: Total which does not change

becki_kain — Thu, 12 Oct 2017 15:50:47 GMT

thanks! it was =sum({1<[TP]={$(TP1)}>}TOTAL Volume)

do I have to save and reload every time I change a variable definition?

Re: Total which does not change

becki_kain — Thu, 12 Oct 2017 15:51:08 GMT

no,that didn't work but thanks. I put in the answer above. thank you!

Re: Total which does not change

sunny_talwar — Thu, 12 Oct 2017 15:51:34 GMT

If you are loading the variable in the script... then yes, otherwise you can make the change in variable overview

Re: Total which does not change

becki_kain — Thu, 12 Oct 2017 15:54:31 GMT

thanks. yeah, these are variables in the variable settings not load script because they change with user entered values

thanks again! this is NOT user friendly (for the first couple of weeks)