I have a variable that formats a string in a particular manner and returns the string. There are instances where this will return a null, which is by design. However, instead of it returning - (the qlik representation of null), I would like to to return a string 'Empty'.
Variable is vConcat_String
if I do: LEN($(vConcat_String)) I get the length of the strings returned if there is a string to return, but on null, I still get '-'.
I have tried wrapping it in an isnull() function like: =if(isnull($(vConcat_String)), 'Empty', $(vConcat_String)) and it continues to express null values to '-' in the table. I have also tried LEN: if(LEN($(vConcat_String)>1, $(vConcat_String), 'Empty') but the null value still expresses to '-' instead of 'Empty'.
Any suggestions?
Hi using this formula to calculate cumulative but its not working - works for a few lines then seems not to work
RangeSum(Above(SUM(SUBMITTED_THP),0,3))
I know its not possible to do a cumulative view in pivot as if there is a zero it cant see past that value
Hi Team,
I am getting below error while connecting to the redshift target.
While I am able to connect from production server. since this is poc instance for redshift. I need to connect it from the Poc server but I am getting above error.
please help us to resolve this issue.
Regards,
Sushant
I want that a unique value of date is selected and set the max date as default when the app is opened. But the interaction between this two issues does not seem to work well. Anyone knows how could I do it?
Thank you in advance
I am using a Master Calendar for my data model. Data for one set of Load don't have data Post 12th.
But the other has data till 20th.
Due to this I am able to see 0 for the days where there is no Data.
how I can make the view dynamic across sheets.
below is the image where i don't have data post 12th.
Below is the one where I have Data till 20th.
How I can control the Bar chart where I don't have data Post 12 so that it don't show chart where the data is null.
Hi,
I have recently started using Qlik sense cloud and we are using Qliksense November 2022 Patch 7 version of the app. When try to get the totals on top of a bar chart. The text for the total is not clearly visible. Sometimes it is not even readable. I've never faced this issue before but this has been the case ever since we moved to the cloud.
Is there anything I can do to fix this? Please see the attached screenshot
Thanks in advance
Hello, I'm trying to use the Fractile() function to delete outliers from my table, but I can't manage to make it work. Documentation specifying a general <expr> in the first function clause doesn't help either.
I have a numeric colum (Valore Riga) and I just want to keep the most central 99% of data, in order to exclude extreme values from the dataset.
Thanks in advance.
Hi
I am new to Qlik Sense and currently using its Qlik Sense Cloud application. I have few queries if anyone can guide me:
1. In pricing section, it says 50GB/Year Storage Capacity. So if i remove any dataset from the app or cloud storage, will the storage space be restored back?
2. I have noticed that once you create a new app and upload files in it, they don't get organized in a folder within that app you created. How can you organize the files in a folder?
3. I see that I can delete the created but the files that were loaded in it remains and there is no option to delete them. How to do it?
4. How to select first or second row as a header once the file has been uploaded?
5. How can I custom design report or storytelling templates?
6. Is there any option to share the report or visuals in sheet window to public?
7. List of most commonly used calculated functions in Qlik Sense?
8. Best place to learn Qlik Sense advanced and its URL
Will appreciate if someone can answer the above.
Regards,
Sal
Is here asking only for one solution?
Hello everyone,
I recently encountered a business analysis question that has left me quite puzzled, and I would like to seek your insights and opinions on the matter.
The question asked for a calculated expression to display "current year sales versus previous year sales" in a table. However, the phrasing of the question seems to be open to interpretation, which has led to my confusion.
here is the quiz and answer:
The provided standard answer is:
Sum({$<OrderYear = {$(=Year(Today()))}>} Sales)
My proposed alternative answer is:
Sum({$<OrderYear = {$(=Year(Today())-1)}>} Sales)
This expression calculates the sum of sales for the current year, which I think is also relevant for the comparison.
as I was only allowed to choice one answer. but in the questions it asked plural.
Should the question be interpreted to focus solely on the previous year's sales, or is it reasonable to include the current year's sales for a comprehensive year-over-year analysis? what do you think? It is just so confusing.
Hi experts,
I have a big mess with the filters and the set analysis, I have several problems.
I am using 4 main variables - 2 are for the KPIs and 2 are for the other objects.
For each KPI I am using Set Analysis and define each variable to the relevant field.
For example: Sum({<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)
The KPIs should not be affected by any user selection, not even selections in the fields listed in the Set Analysis.
When I added 1 to the Set Analysis, only the mentioned fields (Year, Month, Flag1) affect the KPIs, but that shouldn't happen either.
Sum({1<Year={'$(vKpiYear)'}, Month={'$(vKpiMonth)'}, Flag1={1}>}Sales)
The rest of the objects should affect by user selection in the filter panes.
I need to use the other 2 variables to set a default filter in a filter pane (a dynamic filter that updated every month) - set the value of vSelYear as default of Year and set the value of vSelMonth as default of Month. The user can change this defauld and filter by additional fields. Every selection will affect all objects except the KPIs.
My problem is associating the variable value to a field in the filter panes.
The client prefers that I not use Alternate State for the first problem and refuses to use extension for the second problem.
How can the problems be solved?
Hope I was clear. Many Thanks!
Qlik Staige, an all-encompassing solution that provides the technology, ecosystem, and expertise you need to bring better insights to your business, faster.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Get a hands-on experience with Qlik Data Analytics, AutoML, and Qlik Cloud Data Integration & Transformation Services for Snowflake & Databricks.
Real-time Responses Delight Burgan Bank's Customers.
Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.
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!