Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulopereiraqv
Contributor
Contributor

Chart, Join days from different periods

paulopereiraqv_0-1604340246774.png

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

 

3 Replies
edwin
Master II
Master II

this is very similar to the following:

https://community.qlik.com/t5/QlikView-Scripting/Compare-two-periods-thanks-to-range/td-p/1755129

two periods overlapped in same chart

QFabian
Specialist III
Specialist III

hi, send some data to test your expressions

QFabian
QFabian
Specialist III
Specialist III

but the first thing is create that dimension in the script

QFabian