Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem in the data model and KPIs.
The Facts table consists of several tables (concatenate), and there is a dimension table that contains flags.
I want to count the amount of values in a packet according to a certain flag and I don't get data.
How can I solve this?
Simple example
Fact:
SourceTable | num(Date) | StoreID | OrderID | ItemID | Qty | Amount | GoalAmount | Key |
Orders | 44444 | 001 | 1001 | a001 | 1 | 100 | - | 44444 | 001 |
Orders | 44444 | 001 | 1001 | b002 | 1 | 150 | - | 44444 | 001 |
Orders | 44444 | 001 | 1002 | a001 | 2 | 200 | - | 44444 | 001 |
Orders | 44444 | 002 | 2001 | c003 | 5 | 50 | - | 44444 | 002 |
Orders | 44444 | 002 | 2002 | a001 | 4 | 350 | - | 44444 | 002 |
Orders | 44444 | 001 | 1003 | b002 | 2 | 300 | - | 44444 | 001 |
Goals | 44444 | 001 | - | - | - | - | 700 | 44444 | 001 |
Goals | 44444 | 002 | - | - | - | - | 800 | 44444 | 002 |
Dim:
Key | flag1 | flag2 | flag3 |
44444 | 001 | 1 | 1 | 0 |
44444 | 002 | 0 | 1 | 1 |
44444 | 003 | 1 | 1 | 1 |
Sum({<flag1={1}>}Qty) = 6 --> I received 0.
Sum(Qty) when filtered on flag1=1 --> I received 0.
My final KPI should be like that:
Avg(Aggr(Sum({<flag1={1}>}Qty),Date))
Thanks!!
Dears,
I am making a table that contain many columns and user can select the columns they are interested in.
I separated the columns in groups, so it is easier to search for items.
The problem happened when selecting multiple items in same filter.
In pictures an example, when I select only one under Figures filter, I will get the column but if both selected, they will be hidden.
And here after selecting both:
I am using this code for each Item in the table (Show column if):
=If(SubStringCount('Gross Premium',GetFieldSelections(_FigureField))>0,1,0)
=If(SubStringCount('Sum Insured',GetFieldSelections(_FigureField))>0,1,0)
I Appreciate any suggestions you have and if you have other way or source I can learn from.
Good day,
The previous Qlik Community thread refers: Export total straight table to Excel - Page 3 - Qlik Community - 1620552
Our company currently uses on prem QlikView and Qlik Sense, but plan to migrate to Qlik Sense SaaS in December 2024.
Currently QlikView allows one to dump a Straight Table and Pivot Table to Excel whilst retaining 1) totals and 2) column formatting (background and text colors, etc.).
On prem Qlik Sense also allows data exports from Tables and Pivots to Excel, but without retaining totals and column formatting. This is especially frustrating for troubleshooting purposes when this said data set could potentially contain "dislocated (erroneously unlinked) dimensions" which, as underlying rows, do not technically contribute to the measure totals.
Will this oversight be fixed in Qlik Sense SaaS?
This will address quite a crucial need in my industry.
Please confirm.
Thank you kindly.
Hi
We updated our Qlik Sense enterprise server to the Feb Tech Preview and our QSense services are not starting up.
After running the update we got the following message:
And when trying to start the repository service we get the below error:
We attempted to change the registry setting in the server and also change the location of the postgres DB and this did not fix our issue
Your assistance would be highly appreciated
Kind regards,
Justin
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.
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!