topic Re: Formula works not without selection in QlikView

Formula works not without selection

Frank_Kipry — Fri, 15 Nov 2024 23:38:12 GMT

Hello, I think I have a problem with understanding set analysis properly...

I have 2 dimensions, %Artikel and Datum (material and date) and the formula below.

It works like a charm, when I select one specific %Artikel.

But when I select nothing at all, the result is always 0. (btw, when I select a specific date, the result is also 0 instead of the correct value).

Can you guys help me out where I went wrong? (the picture is just a screenshot of the code)

([Note: The next step is: Min(Aggr(formula, Datum, %Artikel)). in the end I want to see if the predicted inventory goes below 0, in the time intervall today (=vStand) and the lead time (=vStand+WBZ_d)]

//Bestand
Sum({ $< TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {">=$(=vStand)"}>*$<TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {"<=$(=Date(vStand+Only(WBZ_d)))"}>} Menge_Verfuegbar_VBME)
+ Sum({ $< TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {">=$(=vStand)"}>*$<TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {"<=$(=Date(vStand+Only(WBZ_d)))"}>} Menge_Gesperrt_VBME)
//Zukunft
+ Sum({ $< TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {">=$(=vStand)"}, IS_Zugang1_Abgang0_Verlauf = {1}>*$<TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {"<=$(=Date(vStand+Only(WBZ_d)))"}, IS_Zugang1_Abgang0_Verlauf = {1}>} Menge_Bestandsverlauf_VBME)
- Sum({ $< TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {">=$(=vStand)"}, IS_Zugang1_Abgang0_Verlauf = {0}, Art_Bestandsaenderung_Verlauf -= {'gesperrt'}>*< TIMESTAMP_DAY = {"$(=vStand)"}, Datum = {"<=$(=Date(vStand+Only(WBZ_d)))"}, IS_Zugang1_Abgang0_Verlauf = {0}, Art_Bestandsaenderung_Verlauf -= {'gesperrt'}
>} Menge_Bestandsverlauf_VBME)

Re: Formula works not without selection

Marcos_Ferreira_dos_Santos — Tue, 24 Nov 2020 12:26:49 GMT

Hi Frank_Kipry

Have you solved it by yourself?

This kind of Problem is better understood and dealt with access to the QVW.

Although, it seems that it could be a Null occurency on your data.

Re: Formula works not without selection

Frank_Kipry — Wed, 25 Nov 2020 08:52:33 GMT

Sadly I can't upload the QVW...

In the end, I used if-statements, which I still would like to replace for performance reasons (I hate loading bars)

But I will try again to search for Nulls, and if I can't find anything I will close this post.

Re: Formula works not without selection

Carlos65 — Fri, 27 Nov 2020 10:48:03 GMT

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating it. Looking forward for solution.

Re: Formula works not without selection

payslipview — Sat, 23 Oct 2021 03:50:31 GMT

I'll be sure to keep an eye on your post . Looking for the same issue. Bumped into your post . Thanks for creating it. Looking forward for solution.

payslipview

Re: Formula works not without selection

Vegar — Fri, 22 Oct 2021 06:36:23 GMT

I noticed some issues in one of @Frank_Kipry's modifiers.

The Datum modifier Datum = {"<=$(=Date(vStand+Only(WBZ_d)))"} will not calculate whats expected, He did not provide us with details on vStand variable other than it is todays date, but depending on the variable content Frank would most likely have needed to change the modifier to something like this.

Datum = {"<=$(=Date('$(=vStand)')+Only(WBZ_d))"}

This was a very specific solution to an old question that most likely is solved by now. Please let me know if this helped you to solve your specific issue as well @payslipview .

Re: Formula works not without selection

scottmoc — Wed, 29 Jun 2022 06:27:27 GMT

good information over here, Thanks for sharing the info.

AlaskasWorld