Hi all, 

In a straight table, for a specific column - Company 

I have to insert "No value" if the value is null.

I have tried 2 things, both didnt work:

1)  IF(IsNull([Company Name]),'No value',[Company Name] )

2)  if(len([Company Name])<1,'No value',[Company Name]) 

Feels like it worked for me in the past, no ideas whats wrong.

In both cases the expression was valid but the column still shows "-"

Thanks

Hi, 

I am new to Qlik sense and I am trying to show some data on map chart. What kind of data I need to have in order to to show some hospitals and number of patients in these hosptials? Thanks in advance.  

Hello,

We have an application developed that contain a big data model with around 5 millions records in the different tables combined.

The application contains some complex measure and aggregations requested by requirements design.

The sheets load fine when we have two widgets containing like a dozen of dimensions and a dozen of measures.

However some end users insists on displaying all KPIs/Measures and all data in one single sheet. For example in one sheets we have:

• 9 widgets:
  • 4 KPIs
  • 5 tables 
• 21 dimensions
• 51 measures, many contains complex aggregations

The sheets becomes barely usable especially when no filter applied

What is the standard recommendation for qliksense for a single sheet? how many widgets/dimensions/measure should we have a single sheet to not abuse the flexibility of self service?

Thanks

Elie

hey ,

i am trying to load Data To all my app in qlikSense Desktop,

i wrote the script  that loops through all the apps using GetDocList function, and i pass the app name a function That Load The Data via QlikSense JS API (every iteration) but i need to "Wait" for every doc\Doc to be loaded\Updated before the next iteration. can you help me???

another thing i noticed is that if i have an  loadData Error it continues without displaying the error, hoe can i deal with "Load Data" Errors?

My data has dates very very wrong extending to 8201 Year and now I can either remove all the data where Year is more +- current year, but I am thinking of making all the dates which are above a certain date like today+5year to be maximum of 31-12-2099 something like that in floor value, due to date being so out of range Date Picker isn't working and fields tags take it as numeric instead of date I have used floor everywhere for my date values.

P.S. I have already tried advance settings they don't work either, while selecting dates in date picker it says no data available and dates are grey not black like normal.

Hey guys, 

So I have a table that lists multiple product orders for multiple stores. The fields in the table include all kinds of information regarding the seller type, buyer type, product type, etc... However there is absolutely no unique IDs in this table. 

This is an issue since I am trying to make a unique identifier for each overall store transaction (not for each individual product bought). I don't want to touch the data load editor.

Is there a way for me to create a master item dimension that serves as a unique key for each transaction. I want to create a master item that combines multiple dimensions in order to create a unique identifier. How do I write this expression?

Hello,

I have this 2 incomplete datasets and I  would like to assign ids to the first dataset from the second one using hte email field.

Does Qlik provide any ability to perform fuzzy matching? I have millins of records to update and hope to use a Qlik to update some of the records.

My Expectation:

Any ideas is welcomed.

Hi all

I need to add to my report the number of rows that exist in it at any given time. 

I was asked to place this counter on top of the report as a kpi (near the date time)

any Ideas? 

thanks