Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kavieweg
New Contributor II

change the timescale in a bar chart dynamically

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

week.PNGDays.PNGMonth.PNGSelection.PNG

7 Replies
OmarBenSalem
Esteemed Contributor

Re: change the timescale in a bar chart dynamically

You can't conrol that..

kavieweg
New Contributor II

Re: change the timescale in a bar chart dynamically

uiii,,,,,thanks

Employee
Employee

Re: change the timescale in a bar chart dynamically

‌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
Contributor III

Re: change the timescale in a bar chart dynamically

Hi,

what about drill-down dimension?

kavieweg
New Contributor II

Re: change the timescale in a bar chart dynamically

Could work better. Im trying it :-) Thank you

benazirkhan
Contributor II

Re: change the timescale in a bar chart dynamically

Can you post the pick match expression here?

kavieweg
New Contributor II

Re: change the timescale in a bar chart dynamically

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 ';')
;

Community Browser