topic Re: Chart, Join days from different periods in QlikView

Chart, Join days from different periods

paulopereiraqv — Mon, 02 Nov 2020 18:13:21 GMT

Hi everybody,

The dimension of this graph is a calculate Dimension Day and month.

=[Day (#)Wise] & '-' & MonthWise

It will be possible to show the data like this:

23-Out 30-Out 24-Out 31-Out 25-Out 1-Out

I have two expressions with different alternate states

num(Sum( {< PromoOpor = PromocoesWISE::PromoOpor, LojasWise = PromocoesWISE::LojasWise, ProdutosWise = PromocoesWISE::ProdutosWise,
WeekDayWise = PromocoesWISE::WeekDayWise, DateWise = PromocoesWISE::DateWise >} TotBaseImpMAWise))

num(Sum( {< PromoOpor = PromocoesWISE::PromoOpor, LojasWise = PromocoesWISE::LojasWise, ProdutosWise = PromocoesWISE::ProdutosWise,
WeekDayWise = [PR-1WISE]::WeekDayWise, DateWise = [PR-1WISE]::DateWise >} TotBaseImpMAWise))

CAN ANYBODY HELP ME WITH THIS, PLEASEEE

Thanks

Re: Chart, Join days from different periods

edwin — Tue, 03 Nov 2020 13:38:58 GMT

two periods overlapped in same chart

Re: Chart, Join days from different periods

QFabian — Tue, 03 Nov 2020 13:40:37 GMT

hi, send some data to test your expressions

Re: Chart, Join days from different periods

QFabian — Tue, 03 Nov 2020 13:41:11 GMT

but the first thing is create that dimension in the script