Discussion Board for collaboration related to QlikView App Development.
How to create a dashboard that allows the user to toggle between monthly, weekly, and daily. More than that, they also wanted to have different date ranges for each of the options: past 30 days for daily view, past 5 weeks for weekly view, and past 10 months for monthly view.
Hi, I think you can use "Field Group" for this purpose or conditional dimensions with buttons to switch between them. For selecting periods can be used trigger.
Thank you for your suggestion but I don't have the Monthly values in my data. So first I have to derive monthly values?
use governance dashboard option from QMC
>>allows the user to toggle between monthly, weekly, and daily
Use a cyclic group to switch between the periods. Use the GetCurrentField() function with a single chart to create a dynamic set expression, or define three charts and use GetCurrentField() to control the chart visibility.
>>So first I have to derive monthly values?
If the transactions are at a daily level of detail, then selecting a month will sum the daily values for the month.
Hi, Surendra. Not necessary, you can replace them with calculated dimensions