Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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.
king regards,
gino2780
I suggest that you post a sample of your spreadsheet.
Hello,
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.
BR
Serhan
Thank you.
@Serhan Celebi
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?
Edit:
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.
Dimension1: Datum
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.
Hi,
You may need to "uncross" your table using GENERIC LOAD (Generic databases) or using the crosstable load (Crosstable)
Regards,
Bas
Hello,
Yes I mean divide the visualizations. You have a chart but I think it is not insightful. Try not to show everything on one chart.
BR
Serhan
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.