Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
similar to my first question, I am applying default filter to my sheet but this time I have several filters. so I wanted to apply actions to my sheet again.
First filter:
Action : select values in a field
Filed name: FY
The value I want to show is the current year, so I wrote this formula in the value section:
FY= '$(=Year(Today()))'
Second filter:
Action : select values in a field
Field: Period
The value I want to show is the pervious month, so I wrote this formula in the value section:
Period='$(=MonthStart(Today(), -1))'
other filters:
Action : select values in a field
Field: ACC_Type
Value: A
Action : select values in a field
Filed: Level
Value: Level 1
when I exit and come back to the sheet, by default ACC_Type and Level filter the sheet and select A and 1, but FY and Period won't be applied.
Just to try, I removed the formulas and instead just put 2024 as value for FY and 3 as value for Period, and it worked. It filters the table by default when I open the sheet, However, that is not what users wants. They want a dynamic default filter.
let me know how to resolve this.
thank you for your help in advance!!
Hi QV Community, i need help i hope any one can help me.
I have a project to publish a vector image, a map converted to vectors, I have already made the map, it is already connected to the database, on the desktop it works very well, but when I want to see that published image, the report does not show it .
Any idea, Tks.
Hi,
I am frequently getting error visualization objects not found on the server.
I am using may 2023 patch 5.
Kind Regards,
Rahu
I have created a bar chart with data that drills down. I am having problems with calculations in that chart. There are two filters, the bigger one is sports and the smaller one is athletes. Given the 5 biggest athletes in a few major sports, I want the chart to show a % of pay each of those athletes gets out of the sum of all 5 athletes.
My current code looks something like this:
Sum(Athletes_money)/sum(total Athletes_money)
This works when a specific sport is chosen, but when no filter is chosen and the bar chart shows all sports separate, the individual athletes money is divided by all of the athletes that are in the filter. Is it possible to make the denominator the total of just the athletes sports grouping instead of all athletes?
What API should I use if I want to obtain a list of all my datasources in Qlik? For example, I configured a Postgres connection and extracted 2 tables. Now I would like to get this info from the API - table names, table columns.
I am not sure what defines a valid expression for variables in the data load editor:
For example:
INCORRECT: Let vLastExecDate = max(date);
CORRECT: Let vLastExecDate = peek('date', 0, 'table_name'));
OR
INCORRECT: LET vIsS3TablePresent = NoOfRows('check_s3')>0;
INCORRECT: LET vIsS3TablePresent = if(NoOfRows('check_s3')>0, 1, 0);
What am I missing? This is an issue I face every month and I haven't pinned down what makes an expression valid for LET variable creation method.
I'm facing a problem with a combo chart.
I want to show the maximum and the minimum value of a measure (only two highlighters), but minimum highlighter appears repeatedly in every month and far from the line.
Can someone help me, please?
MEASURE (line): count(distinct Chave_Contrato)
HIGHLIGHTERS
Max: =if(count(distinct Chave_Contrato)=max(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)
Min: =if(count(distinct Chave_Contrato)=min(total aggr(count(distinct Chave_Contrato),[Mês Ano Registro Contrato])),count(distinct Chave_Contrato),0)
Thanks!
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.
Hi Folks
I am trying to download files from a Google Cloud Storage Bucket, and I am having an issue with the tGSGet component. I got the below message on "code" tab on Talend Studio
I chose several of the fixes that the tool provided me but any didn't work
could anyone help me with this? thanks in advance
Hi,
I have a workflow, where I need to reload massive csvs into some BI tool. Of course, it is much easier to do, if data is compressed into some format or written as RAM dump.
1st approach (compressed) is used in Qlik and Tableau, qvd and tde respectively.
2nd approach (RAM dump) is used in Parquet/Arrow (I use it thru Python/Pandas).
Question - Is there _any_ compressed or RAM optimized format, supported by Power BI?
I mean, free easymorph can read qvd and tde (Tableau), but Power BI can't?
Free python/pandas can read/write RAM optimized files, but Power BI can't?
xlsb (binary Excel) is great, but Power BI is extremely slow with it, even it is the MSFT technology.
Also, Power Bi desktop can't read another pbix (at least I don't know how to do this).
Any suggestions? Thanks!
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!