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 !
Hi
We have 2 QlikView Server installations. One version 12.60.2 and one version 12.70.2. Version 12.70 is newly installed from scratch and setup exactly as version 12.60 except from different shares and different hardware.
Same setup. Same domain. Same users. Publisher License Enabled.
QlikView Document and Source Document administrators works fine on version 12.60 installation but NOT on version 12.70 installation. Setup is made like
https://community.qlik.com/t5/Official-Support-Articles/How-to-set-up-Qlikview-Document-Administrators/ta-p/1712271 using AD group membership.
On version 12.70 Group members are not authenticated. If we use individual user and not group authentication then it works fine. On documents using the same AD Group the authentication works fine, so the QMC has fine access for reading the AD Group membership. It is only for the Source Document and Document Administrators AD Group membership is not working.
Anyone with a suggesting where to look for the solution ? Or could it be that the Group Membership bug from version 11.20 has sneaked in again in version 12.70 ?
Snip from above “How to setup QlikView Document Administrators” :
"Note: In QlikView 11.20, you cannot use groups. Membership is restricted to individual users. With QlikView 12.xx groups are fully supported."
Thank you in advance for any comments for a solution on the this 🙂
Good morning
we have some CDC Qlik task (Full+CDC) that reads from Db2 for z/Os Sources Endpoint and write to MS Big Query or Kakfa Target Endpoints.
We like to use a Db2 for z/os Log Stream Source Endpoint and we already have a Log stream task and some CDC Qlik children dependent on it.
Our issue is how to migrate Source Endpint form Z/os to Log Stream without disservice or issue on CDC Qlik task that does not use Log Stream yet : on top of candidate migration CDC task thare are some services with Business Continuity 24*7
We can't accept any loss of log event / modification / data during the process.
What are Qlik best practises for this scenario ?
Let me know
Regards
A. Ferrario
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?
ID | Field1 |
1 | A |
2 | A |
2 | B |
3 | C |
4 | A |
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..
ID Number | Category | Value |
1 | Cause_Reason | Software |
2 | Cause_Reason | Power Supply |
3 | Reqeq1 | Cabling |
4 | Reqeq2 | Order new |
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'm trying to load only the previous month's data from the data arehouse.
I'm trying to use the following condition
WHERE MonthStart(flt_date)=MonthStart(Date(Today())-1)
But there seems to be an error which prevents the loading of the data.
Previously, I have been using the following WHERE statement and it was working without any problems.
WHERE flt_date>'2023-06-30'
However, I wanted to limit the data loading a bit more dynamically than changing the dates each month.
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.
Qlik Staige, an all-encompassing solution that provides the technology, ecosystem, and expertise you need to bring better insights to your business, faster.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on Sept. 27th at 10 AM ET for the next Do More with Qlik session, where we will be featuring Insight Advisor – our intelligent AI-assistant in Qlik Sense.
Real-time Responses Delight Burgan Bank's Customers.
Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!