Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am attaching the very basic app with just two rows of data of type Date.
Visualization are created with Dimension as Year for the date in one of the columns
While measure is count of the number of instances the date occurred in a year.
But the visualization is not working. Earlier I used the same concept to build our apps. Can you please take a look and let me know if I am missing something?? !
There is no data in your application. The table you have loaded has just null values
To be specific you have 8263 rows with null values in both fields... so something is strange with you source data. Usually when you load from an Excel file it is not necessary to do an explicit date conversion as Qlik Sense understands Excel dates.
@Peter Skjolden Thanks for the reply.
You might be correct, this may be the reason my Qlik sense doesnot identifies the content in my column.
But I am able to see the content in the data manager.
Do you know why my Qlik Sense is not able to identify the content??
You should try to load the data without attempting to do date conversions. How does the Excel spreadsheet look like. Do you have a sample or are you at liberty to share the real spreadsheet?
I tried doing that too but in this case Qlik doesnot auto identifies the date.
Also the visualization doesnot works.
Also, the spreadsheet works perfectly when using Qlik Desktop.
While it doesnot works in Qlik Sense cloud and Qlik Sense Enterprise.
I will try to upload the file.
I had a look at your source data and then unlocked the "Auto-generated section" in the load script editor. Then I deleted the unnecessary second LOAD and made sure that the field names of the first load was PR6 and PR3 so they correspond to the Excel-file. After reloading everything worked fine with valid dates in Qlik Sense.
Thanks peter for finding out the root cause.
But I don't do anything with the data load script.
I only work with Data tables and Data manager. How could I work on Data Manager to fix this??
Because if I change the load script it wont allow me to access the Data Manager.