Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Data Quality, Preparation & Stewardship
Hello. I have a table in table format, and you can add columns to it by selecting them. There are quite a few columns. There are three accounts that can access this table, and what I need is for only the selected account to be able to select all the columns. Other accounts should not be able to select all the columns.
Hello:
We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as it is being replicated?
Thanks,
Manas.
I am trying to calculate the sum of the debits for the current month using the formula below. I'm not sure what I'm doing wrong here because I get only 0s with this formula.
sum({$<GL_Month={"=$(=Date(Floor(MonthStart(Max(ActualsDate))),'MMM-YYYY'))"}>}Accounted_Debit)
I want to calculate the value for the previous month as well.
GL_Month is the month column that is derived in the script with the following formula :
Date(MonthStart("ActualsDate"), 'MMM-YYYY') as GL_Month,
The dimensions of the bar chart are Site, Measure 1 is Days1, Measure 2 is Days2, Measure 3 is Days4. I want Days1 to be displayed in white, Days2 in green, and Days3 in red. How do I write the color expression?
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
Hi There,I have n number of columns in the table and I would like to apply rank function on below variables based on latest survey date where i can filter out rank = 1.
Appreciate your advice.
Something similar to SQL Query.
rank() over (partition by COUNTRY, STATE order by survery_date desc)
from table
where rank = 1
Dear All,
We have a dashboard where all these calcs which you see are KPI's. The reason to use KPI is to see the up or down arrow with color to see performance. But while we load the page, it is taking too much time.
Please suggest what is the best way to represent same data with optimized sheet loading.
thanks in advance.
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!