Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
could someone tell me, how can I export a table from QlikView along with formulas in it? The total SUM is not being calculated correctly an I do not know why. That way i could see it.
thanks
Buenas tardes, tengo un detalle en mi servidor, anteriormente ya me había pasado, investigando en el foro, encontré que el que provocaba el problema era el protocolo (TCP/IPV6), lo que hice fue desactivarlo desde el adaptador ethernet y solo dejar el (TCP/IPVv4 ), reinicie servicios y con eso se soluciono.
Ahora me volvió a suceder despues de mas de un año, pero no he podido encontrar la solución, lo ultimo que he realizado es intentar modificar el archivo
pg_hba.conf de la ruta C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
host all all fe80::3154:e42:5c:875%7/128 md5
host all all 172.17.52.237/32 md5
La ip es la misma, ayuda 😞
Buena tarde.
Estoy haciendo un modelo con qlikview v11. Como puedo poner un filtro fijo a una tabla y en una segunda tabla poner otro filtro. En ambos casos el filtro es sobre el mismo campo. Por ejemplo.
Tengo una tabla simple que tiene como dimensión: Catálogo
Sus valores de la dimensión Catálogo son: Pago, Devolución, Nota de Crédito
Entonces, quiero tener una tabla con un filtro fijo, el valor Pago. Que la tabla solo muestre el resultado de valores que tengan que ver con ese valor y en la segunda tabla que muestre Devolución y Nota de crédito.
Saludos
Hi All,
I have text box in Qliksense and I have mentioned Required text in text box.
My system it is showing proper and some one having issues like if there are seeing dashboard in bigger screen then the font size will changes.
Can please suggest me how to handle when moving from smaller screen to bigger screen or bigger screen to smaller screen the font size won't change.
Thanks & Regards,
Lakshman
Hello Community,
Recently I discovered that I can make que QlikViewServer Service make a CalData.pgo.xml, so i wanted to do an app to see the document cals assigned and last used, but the Last used date comes encrypte like this:
I want to know if is there any way to decrypt those dates so I can do some kpis with them.
Thank you.
Qlik Compose for Data Warehouses
how to read pdf file which contain text, graph and tables also but i want only load table data into database, what should i do? which custom component used?
Hi
When a pie chart or a donut chart is natevely created in the PixelPerfect template, there is a bug displaying the last label of the percentage.
In fact if the last percentage and first percentage values are between 1% and 3% than their label get swapped clockwise after the first label. Wrongly displaying the labels.
The Resolve Overlapping Mode property behavior does not move the label to the right side. See attached images.
It happens on all NPrinting versions.
How can this be fixed?
Kind regards
Hatus Peters
Hi all,
I have 2 fileds: AccountID and Scope. Some Account does not have a Scope (null in scope) and I would like to find them. I can work only in Front End, so no load script can be used.
E.g.:
Account | Scope |
1234 | Scope 1 |
2345 | - |
345 | Scope 2 |
I managed to create a KPI that show how many Account with null scope I have, with the formula
count({1}distinct AccountID) - count({1<[Scope]-={"-"}>} distinct AccountID)
(note that the formula "count({1<[Scope]={"-"}>} distinct AccountID)" gives a wrong answer: always 0.
Now I would like to see WHAT are those AccountID.
I tried a table with the dimension column "AccountID" and the measure column "Count({<Scope-={"*"}>} AccountID)", but it doesn't work
Neither does the measure column "Only({<Scope={"-"}>} AccountID)" (it gives only one one full-null row)
Neither "IF(Count({<Scope={"*"}>} AccountID))=0, AccountID)" (it gives only one one full-null row)
Thank you for your help
I've got a table that tracks sales across various stores and regions. One of my filters is on the "Store ID". I want to exclude the following three values from my "Store ID" filter:
I can't exclude these in the data load, I have to do it with set analysis. I've tried this but I get an "Expression error" error when writing the "Store ID" filter function in the listbox properties:
={< [Store ID] -={"280-NEI hidden", "414-XUE hidden", "783-VTO hidden"} >}
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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!