change the timescale in a bar chart dynamically

[kavieweg]

Hi Together,

I have the following Problem: I need to change the timescale in my bar chart dynamically. In one case I need Days displayed in another week or month. I found a solution for that (by using pick match) but if i select a date or range it automaticly set the filter for week, month and day (the picture). What I want is, that only the date filter is shown.

Thanks
Mathias

[OmarBenSalem]

You can't conrol that..

[kavieweg]

uiii,,,,,thanks

[SteveNewman]

‌ccan you use time aware charts that will enable dynamic ranges based on the current selection?

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Visualizations/time-aware-char...

[DavidŠtorek]

Hi,

what about drill-down dimension?

[kavieweg]

Could work better. Im trying it 🙂 Thank you

[Anonymous]

Can you post the pick match expression here?

[kavieweg]

pick( PeriodDrill_ID,

Year,

Month,

$WeekYear,

Date

)

PeriodDrill is defined in Load Script:

PeriodTypes:

LOAD * INLINE [
TimeScale; PeriodDrill_ID;DateFormat
Years-Qu.;
Months; 2
Weeks; 3
Days; 4
] (delimiter is ';')
;