Bonjour à tous 🙂

Tout est dans le titre 🙂 J'aimerais créer une dimension calculée depuis une autre dimension calculée 🙂

J'ai plusieurs supports que je souhaite ranger dans des "tiroirs", qui devront également être rangés dans un plus grand tiroir. Je m'explique 🙂

Je suis entrain de créer actuellement une dimension calculée qui reprend en fonction du support, une catégorie.

Par exemple :

Si 'XXX' alors 'XXX - Print'

Si 'xxx' alors 'XXX - Print'

si 'YYY' alors 'YYY - Print

Jusqu'ici tout va bien ! 🙂

J'aimerais ensuite que si 'XXX - Print' et 'YYY  - Print'       alors     créer une dimension calculée par exemple "GENERAL - PRINT"

Est-ce que cela est possible ? 🙂

Merciii par avance pour vos retours !

I'm using Field1 as a dimension.
ID can have one or two values in Field1, one letter or one letter and always B, see ID 2.
But now I want Field1 split into a new dimension. In this case - I want a new Field2 with the value A for ID 2 and ignore B from Field1. It should always take the other letter and ignore B. If Field1 only contains one letter (lets say A), Field2 should not do anything.
How I do that?

A client of us is migrating from a Qlikview to a Qlik Sense environment. All of their apps are built with Qlikview , including a couple of custom visual extensions. (in this case a custom toolbar)

Using the management console from the Qlikview server we distributed a Qlikview document to a shared Qlik Sense environment. 

However, extensions are not included in this distribution. Re-building this extension in Qlik Sense is (as far as I know) not a possibility because the Qlik Sense extension doesn't interact with the app built in Qlikview. 

My question in summary is this: Is it possible somehow to have an extension built for a Qlikview app working when said app is hosted on the Qlik Sense environment? 

(fyi i'm relatively new to Qlik, hope you all understand what I mean and this question is asked in the correct place)

Thanks in advance!

In einer Tabelle mit Buchungsdaten strebe ich an, die jüngste Buchung mit dem Vermerk "Wareneingang" zu identifizieren und die aktuelle Menge in einer anderen Spalte darzustellen. Dieses Vorhaben habe ich erfolgreich mit der Verwendung der Funktion "FirstSortedValue" umgesetzt. Wenn keine spezielle Filterung angewendet wird, weisen die Spalten "Menge" und "Kosten" lediglich Nullwerte auf. Sobald jedoch ein bestimmter Artikel ausgewählt wird, funktioniert alles reibungslos und zeigt die korrekten Werte an. In meiner Formel kommen die Funktionen "aggr" und "FirstSortedValue" zum Einsatz, um dieses Ziel zu erreichen.
Seiht ihr bitte den Anhang.

Formel: Sum({<[BC_Description]={"*eing*"}>}Aggr(FirstSortedValue([Stock, -[ID]),[Warehouse], [Condition]))

Die Frage, die sich jetzt stellt, ist, wie ich die Menge für jeden Artikel in jeder Spalte ausgeben kann.

*Zum Anhang. Spalten auf Englisch (von Links nach Rechts): Tool, Last booking, Storage period in days, Current stock amount, Current stock value

I have a table from a large database, where if a value in one column meets a condition the resulting values in another column gets to be a new field:.  For example any category with Cause Reason all the data in value can be summarised in a new field, called Cause/Reason that will give me Software, Power Supply etc..

Hello All,

I have a user requirement to show blank row after each dimension field value. Please can someone let me know how can i insert blank record while loading the table into qlik sense? I have attached the sample data and the expected output.

Thank You!! 

I have uploaded a QlikView app to our Qlik Cloud tenant, into a shared "Development" space.  From there I published the app to a "UAT" space.  In the UAT space I can see the published app and the publish date, so I know it published successfully.  

However, when I look at the details on the app in the Development space, the "Published copies" section shows no history and says, "There are no published copies to display.  This app has never been published."  I expected to see the publish history here.  

Is this intentional behavior because I am working with an unconverted QlikView app?  Or should expect to be able to see the publish history for the app since it was successfully published? 

Edit:  I confirmed that publishing another native Cloud Sense App from and to the same Spaces does work as expected, with the publishing history available from the source app.