topic Re: Show value despite selectionfield in QlikView

Show value despite selectionfield

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

Hello everybody,

I have a problem an no idea to solve it.

I trie to explain it in english 🙂

The table consits with the sales and the orders in process.

Then we have a selection-field for the month. We can choose for example only one month or an space of time, for example January to July.

For the sales it works in both cases. But for the ordes in process, qlik view should show me everytime the last value, despite which month oder which space of time / month i have choose.

Can someone help me with a tip for a correct formula in relation to the orders of process?

Best regards

Johannes

Hallo Zusammen,

ich habe ein Problem und aktuell keinen Lösungsansatz.

Ich habe eine Tabelle mit einer Spalte in der Umsätze gelistet sind. In der Spalte daneben ist der Auftragsvorlauf gelistet. In unserem Auswahlfeld kann man nun nach einem Monat filtern, oder nach einem Zeitraum, beispielsweise dem Quartal.

Bezogen auf den Umsatz ist dies auch sinnvoll. Jedoch möchte ich bezüglich des Auftragsvorlaufes eine Formel bauen, das mir trotz der Filterung immer nur der letzte eingetragene Wert angezeigt wird, egal ob von diesem oder dem letzten Monat.

Vielleicht kann jemand helfen.

Liebe Grüße

Johannes

Re: Show value despite selectionfield

tresB — Wed, 18 Sep 2019 10:38:21 GMT

This could depend on your data model. Usually I would use FirstSortedValue() for similar requirement. Have a look at it. If you need help in more detail, try to share a sample app to work on.

Re: Show value despite selectionfield

JohannesJulius — Wed, 18 Sep 2019 11:16:23 GMT

Thank you for your reply 🙂

I have trie it. Now the formula disconnects the whole table from the selection fields, so also the sales column.

I think you are rigth, that the problem is the data model.

In my mind, I think there was a formula for these cases, but I don´t remeber.

Re: Show value despite selectionfield

Brett_Bleess — Mon, 30 Sep 2019 16:17:17 GMT

Johannes, the closest thing I have that I think may help is the following Design Blog link. Feel free to search that area yourself as well, just back the URL up to the Qlik-Design-Blog/ level and you can search from there...

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

There may be another way to do this via Set Analysis as well, so I am including another Design Blog post for that too:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

My post will also move things back up in the conversation, so someone else may see the post and offer some other ideas too.

Regards,
Brett