topic Re: Daten von gestern anzeigen in QlikView

Daten von gestern anzeigen

merry2018 — Mon, 30 Jul 2018 08:51:19 GMT

Hallo Zusammen,

ich benötige mal wieder eure Hilfe und zwar möchte ich in einem Diagramm die Daten von gestern anzeigen, ohne das eine Auswahl auf Tagesebene getroffen wurde.

Es wird immer nur die Woche ausgewählt und trotzdem soll heute die jeweilige Schicht von gestern gezeigt werde, wozu es drei (F, S, N) Diagramme gibt, für jede eine.

Überlegt habe ich es zb. folgend:

sum({<Tag={'max(=$(=(Tag)))'}>}if(Schicht='F', Dauer))

Aber sicher bin ich mir nicht, da das eigentlich ja vorschreibt, dass der aktuelle Tag selektiert ist, was aber nicht sein darf, da parallel auch Diagramme sind welche die ganze Woche zeigen oder so.

Danke für eure Hilfe schon mal und Grüße

Merry

Re: Daten von gestern anzeigen

felipedl — Mon, 30 Jul 2018 11:24:48 GMT

Hi Merry,

If your day field is a number (or dual representation, with number and text) you can do arithmetic operations to add days on it to show the previous day.

sum

(

// gets the max day (selected or not) and subtracts one to get the previous day

tag = {"$(=max(day)-1)"},

// shift type F

shift={"F"}

duration

)

Re: Daten von gestern anzeigen

merry2018 — Mon, 30 Jul 2018 11:45:22 GMT

The field day i don't have, which you mean there I can taken?

Can I do some with the today() or the same fild, so i mean Tag?

Re: Daten von gestern anzeigen

felipedl — Mon, 30 Jul 2018 11:49:33 GMT

Ah, sorry Merry, the browser translated the Tag to day automatically from German to English.

What's the datatype of your Tag field, when you put it on a listbox, does it align to the left (meaning it's interpreted as a text) or to the right (interpreted as a number).

You could use today()-1 for instance, if you have a numeric or dual type of data.

Re: Daten von gestern anzeigen

merry2018 — Mon, 30 Jul 2018 12:41:50 GMT

It is a number, because it align to the right.

Ok, now I think it's working.

Thank you!

Re: Daten von gestern anzeigen

felipedl — Mon, 30 Jul 2018 12:47:55 GMT

Glad it helped .

Can you mark the anwser that helped you as correct so other in the community might see it as well?

Regards,

Felipe.

Re: Daten von gestern anzeigen

merry2018 — Mon, 30 Jul 2018 13:45:12 GMT

If i use today(), probably i should use the KeyDatum, that they have the same Format (both 'DD.MM.YYYY') and not only one with Day and one with Date?
For that way is that the correct form:
<%_Key_Kalender= {"$(=(today()-1))"}>

or what is wrong, thats not working?

-Merry

Re: Daten von gestern anzeigen

merry2018 — Tue, 31 Jul 2018 05:49:03 GMT

Yes I will do, if I am finshed and have the correct way.

Re: Daten von gestern anzeigen

merry2018 — Tue, 31 Jul 2018 12:00:13 GMT

I have solved it now via a flag in the calendar, because I unfortunately did not get the formula and the first did not work completely.

Re: Daten von gestern anzeigen

felipedl — Tue, 31 Jul 2018 12:28:53 GMT

Good to know Merry post your solution and mark it as correct, might help other on the community.

Re: Daten von gestern anzeigen

merry2018 — Wed, 01 Aug 2018 05:16:07 GMT

That solution is only, because the other don't work.

I would like to get that formel right:

sum(<%_Key_Kalender={"$(=(today()-1))"}>if(shift='F', Time))

Did some one know what is wrong with that formel?

Re: Daten von gestern anzeigen

felipedl — Wed, 01 Aug 2018 10:46:54 GMT

Hi Mery

The today()-1 returns a textual representation of the date, and your %_key_kalender might be a number, not giving the right result.

Other thing is, that the if statement your doing could be incorporated to the set analysis, like so

sum(<%_Key_Kalender={"$(=Num(today()-1))"},shift={'F'}>Time))

That will sum up the last day's and shift "F" time.

To see what's going on, add a simple straight table with your formula, and hover the mouse over the expression header, that will show you what the set analysis is returning.

Could you post that and the %_Key_Kalender field on a screenshot to check what might be wrong?

Re: Daten von gestern anzeigen

merry2018 — Wed, 01 Aug 2018 12:13:34 GMT

Thanks for try to help.

Maybe there 2 breaks "{}" missing, but it's not gooing as well, with that:

sum({<%_Key_Kalender= {"$(=num(today()-1))"}>} Time)

from the table I can not make a screenshoot, because its called "No data available".

The Kalender Field are the following:

Date(Datumsfeld_tmp.Datumsfeld, 'DD.MM.YYYY') as %_Key_Kalender,