I am new learner in QlikSense. Could you please help me out, how to solve below:
- Create a filter named Time-Period with values as ‘YTD’,’MTD’,’QTD’,’WTD’, filter for Month, Quarter,Week.
- Create the line chart to show the sales that changes as per your YTD, MTD, QTD, WTD selections. Dimension should dynamically change as per the selection for eg:
- For YTD, dimension should show values like MMM-YY
- For MTD, dimension should show values like Day numbers
- For QTD, dimension should values like MMM-YY under the selected quarter
- For WTD, dimension should show values like Day names
- Create a KPI which shows consolidated values as per time-period selection :
- ignore the selection for Month,Quarter,Week when YTD is selected,
- Ignore the selections for Year/Quarter/Week when MTD is selected
- Ignore the selections for Month/Quarter/Week when QTD is selected
- Ignore the selections for Year/Quarter/Month when WTD is selected
- Create a column to get the dates in the format MMM YYYY. Use this as a filter and create a chart which shows you the rolling 12 months sales basis the selection in this column.
- Create a map to show the sales for each of the customer regions
- Create a sheet wherein you have two charts to work on comparative analysis to show the sales and quantities of orders on dual axis. These chart should give the details of 2 products each in 1 chart. Allow the selection of the column Year on both the charts.
- Create a table which gives you the details for sales for all the products. Ignore the selection of Products on this chart