i'm new to qlik sense and want to make an app that visualizes a crosstable with date stamps in a diagram.
My crosstable looks like this:
I've tried to set up a bar chart, but couldn't figure out how to visualize all the information shown in the excel-file in one diagram.
I'd appreciate your help. Thank you in advance.
Simply divide the information for visualizing it with different charts.
1. Line Chart --> Date and Measures: showing a kind of trend
2. Pie chart or Bar Chart--> Status or % Status and Measures: Showing the distribution of the statuses.
3. Pivot or Table-->All details, like a sample screen you sent above.
What exactly do you mean by 'dividing the information'? Are you refering to the excel data or the visualization only?
In other words: Do you suggest to construct any 'help' tables out of the excel table or is it even possible to build this app with the full table as the one and only data source?
Here is a screenshot of what i've got so far:
But, this bar chart only visualizes one column of the excel file, e.g.
Dimension 2: Status
Identification number: cloumn 1 (CIT-ABRE) of my excel file
I can't figure out how to set a filter to pick a column of my choice for the visualization.
That's not the point. The problem was rather that i wasn't able to pick each column (see spreadsheet) while having already two dimensions and a measure defined.