Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working on financial KPI's and want to use the balance sheet as well as the P&L for analysis.
The differences is that in the balance sheet you have an ingoing balance and then the changes during the month is booked and then you get an outgoing balance, in my dataset there is no ingoing balances available from the database from any tables that I've found.
I want to to a rolling 12 months analysis on inventory turnover rate and need to be able to calculate averages for a twelve months period every month ending to get this KPI.
I've added the ingoing balance for 2021-05-01 manually and concatenated with the transaction data, from this I can get an outgoing balance every month with RangeSum and Above where I've set period of times to 100000, (maybe there is a smarter way) which gives me the outgoing balance every month.
RangeSum(Above(Sum({<Sub_Group={'Inventory'}>}Amount),0,100000),)
How do I use this? I need to bring the value from 2021-05-01 to 2024-03-31 for example to be able to get my outgoing balance for 2024-03-31, see example below.
Is there a way to make a calculated field instead to use in set analysis or any other way that is more simple just shoot with ideas!
Help much appreciated, thanks!
Hi,
I'm wondering about a certain scenario.
Say for example, there is a large table that needs to go to an ADLS target using parallel load, and there are 5 parallel segments.
Is there a possibility of say segment 4 loading before segment 3? Thus resulting in incorrect sequence in ADLS.
Also, are there any best practices regarding loading very large static tables to ADLS? My only current idea is parallel load. Thank you
Regards,
Mohammed
Mohammed
Buen día comunidad
Requiero ayuda con lo siguiente, tengo dos tablas:
Historico: con el campo ID:[1,2,3,4,5]
Mes: ID[1,2,6,7,8]
No he podido hallar la forma de cruzar las dos tablas para obtener los registros no coincidentes, lo que deseo es saber mediante un script los registros de la tabla del Mes que no están en el Histórico
I have a map below, which related food to fcode. fcode is the key that links multiple tables together.
map1:
[food,fcode
apple,a
apple-pie,a
banana,b
banana-float,b
cherry,c
cherry-coke,c];
Let's say
Table 1 -uses fruits (applymap() can be used to turn food into fcode)
Table 2 -uses fcode (can not reverse into food)
Table 3 -uses fcode (can not reverse into food)
How can i create a filter, such that:
1. the filter display the food values. (i.e apple-pie and not 'a')
2. When selecting food values, the filter is applied to all tables (1,2,3). I.e if I select apple-pie (or apple), the filter also set fcode to 'a' and table 2,3 will display only information relating to 'a'. Note that it is accepted for either apple-pie or apple to be selected to filter for fcode 'a'
If I use applymap() on table 1, and filter by fcode, i lose context for my users who only understands food.
Can we create custom banner in Qlik Saas.
We have to display message on Hub if there is any planned maintenance or data refresh failure.
This facility is available in Enterprise version. But didn't find on qlik SaaS.
Hei,
I have somewhere seen an object that could hold a lot of values like a table.
Every measure could be written separately.
How you please help me out?
P.S. Qlik Sense on prem version
Hi All,
How to sort data based on leading zeros and not the actual number in qlik
Below is my example
Item Num |
0064 |
000670402 |
0065FR |
CS-CD-PSW-10-00 |
010240410 |
The data should be sorted based on number of zeros at the start in ascending order.
My final output should be like the below table
Item Num |
000670402 |
0064 |
0065FR |
010240410 |
CS-CD-PSW-10-00 |
Note : This is just an example . I have more that 30000 item numbers like this and i want to sort based on number of leading zeros
Hi, everyone!
My last question was about making partitions from one QVD to several smaller.
And kind user Brunobertels sent me a link to a post, how to do automatic partitions.
And now, I have many pratitioned QVD-files and task:
I have to load those QVD-files which have only data by asked dates in ODAG request.
I just made a next script:
//first check if it's not an ODAG request, but a common load from current window
if '$(odagActive)' = '' then
set 'odag_Date' = '''01.07.2019''';
end if;
[Tasks]:
LOAD
TaskID,
ContactID,
CompanyID,
CreationDate,
TaskExpDate,
EditDate,
TaskStatus,
CreatedUserID,
ResponsibleUserID,
TaskName
FROM[lib://DataFiles/CRM_Tasks_*.qvd](qvd)
where Match(CreationDate,$(odag_Date));
But as you can see, it's a bad script, coz it loads all the files(((
Please help me to load exact files with dates which was requested.
Here's my QVDs:
lib://DataFiles/CRM_Tasks_m01_y2019.qvd
lib://DataFiles/CRM_Tasks_m02_y2019.qvd
lib://DataFiles/CRM_Tasks_m03_y2019.qvd
lib://DataFiles/CRM_Tasks_m04_y2019.qvd
lib://DataFiles/CRM_Tasks_m05_y2019.qvd
etc till the end of 2020.
Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size&shape properties, there are two layers point layers and area layers, except size&shape all the properties are dimension, so How should I stop the dimension from reflecting from year-month?
right now after selecting it is removing countrys(area layer) and some station(point layer) when I select year-month.
Used expression: SUM({<[YEAR_MONTH]=>}[GEO_AVG_PRICE] * [GEO_QTY])
Before selecting year month filter:
after selecting (it shouldn't change anything, It should show the map as it was before as in above image):
Hi All,
I have sheet and i want to add images as sheet background. there is no option in sheet properties in my current version in my organization.
I am trying to add using html and css but it's not working properly.
.qv-panel-sheet {
background-image: url("C:\Users\Desktop\1600w--kbTNqEWceg.png");
}
Can you please suggest me how to do this scenario in Qliksense.
Thanks & Regards,
Lakshman
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.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
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!