I am new to Qlik and not familiar with the App and expressions.
I have Data from Excel file and data from CSV files.
The CSV file is what Makes my Facts table. This data is data we collect when we are conducting surveys. When we conduct these surveys we ask questions we requires Response in form of
Text strings
Dates
numeric
My major problem is how best Can I analyse this Data as this 3 different type of Data falls in the same response column and my text strings requires simple counts while Dates and Numeric requires special grouping and calculation. Should I maintain these 3 in the same column or I have to split them into 3 Different columns? If I have to split them How Best can I split them? If I maintain them in the same column how can I write the script conditions that if response is text then, if its date then and if numeric then.
My Excel files contains geographical location information, customer Details and some question specific parameters (which determines the specific calculations required for that question). I have made these files to form my Dimensions Table. Is this the proper way to create my data model?
I would also like to compare the number of customers who respond to a certain question over the total customer base as I drill down( thus by Region, Country, District ,City and Suburb). Would prefer to write this in the script compared to UI. As I will be drilling down I would also Like a Table showing me the details of the customers who will not Have responded.
