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 Team,

I am getting below error while connecting to the redshift target.

• SYS-E-DESERIALERR, Failed to deserialize json to type BrowseConnectionAsyncReq: Unexpected character encountered while parsing value: {. Path 'db_info.db_settings.s3Region', line 1, position 282..
• SYS,DESERIALIZE_TO_TYPE,BrowseConnectionAsyncReq,Unexpected character encountered while parsing value: {. Path 'db_info.db_settings.s3Region', line 1, position 282

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

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

Qlik Sense Business Qlik Cloud 

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:

My proposed alternative answer is:

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!