Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table problem - Time Dimension vs MTD, YTD

Hi Community,

I am trying to create the below chart and I can't make it happen:

TimeDim Vs TimeExp.JPG.jpg


I am facing 3 problems:

  1.The user needs the Market & its Products in one column like above. the first red circle represents the Market and the second circle represents the Products that Market have. How do I show into Pivot table ?

  2. How do I create the MTD & YTD values for Time dimension value ?

  3. Market growth = CURRENT_MONTH/ LASTYEAR_CURRENT_MONTH. How do I calculate this expression if I have the time dimesion ?

Thanks in Advance....

1 Reply
valerio_fatatis
Partner
Partner

Hello,

you can find a good example in the same community.

A Rapid "Fast Calendar Selections...", a great boost of multi periods analysis! ...

Using a master calendar for "concatenate" function by entering "InWeek, InMonth, InYear etc ...

The objects are functioning.

Thanks

valerio fatatis - Sebior BI Qlik Specialist