topic Re: calculate without selection in QlikView

calculate without selection

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

Hi, somehow I can not get any further,

I have a formula that works on its own and also calculates what I expect 🙂

Only you should calculate the value without the selection of the user in the "year" to observe, so always pay attention to all values of all years.

The function "Year =" or the 1 do not do what they should, namely not to consider a possible selection.

What is wrong in the formula?

Thank you very much for your time and help ....

=count({1<Jahr=, forderung_StornoFlag = {0}>}Aggr(If(Only({1<Jahr=, forderung_StornoFlag = {0}>}forderung_Datumskennung) = Max(TOTAL < forderung_Nummer_eines_Belegs_des_Vertragskontokorrents> forderung_Datumskennung), Only({1<Jahr=,forderung_StornoFlag = {0}, forderung_InformationFlag = {0}, forderung_MahnstufeFlag = {0} >}forderung_Gemahnter_Betrag_in_Transaktionswaehrung)), forderung_Datumskennung, forderung_Mahnstufe, forderung_Nummer_eines_Belegs_des_Vertragskontokorrents))

Re: calculate without selection

sunny_talwar — Sun, 21 Jan 2018 15:40:27 GMT

Would you be able to share a sample to show the issue?

Re: calculate without selection

neapicture — Sun, 21 Jan 2018 15:54:30 GMT

I have a selection box where I have to select the year for other charts and calculations.

Only for this calculation of "reminders" the selection of the year may not be considered.

Is that what you meant?

Re: calculate without selection

neapicture — Sun, 21 Jan 2018 20:29:26 GMT

In the Max (TOTAL <...> ....) function, I have added a corresponding set expression. It works now