Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mharm
Contributor

toggle between charts or drill down??

EmpDateSt    EmpDateEnd    FYStart       FYEnd         FYFlag      QuartSt         QuartEnd       QFlag        MonYear       MYFlag

1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               1/1/2017       3/31/2017         1              Jan 2017        1

1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               1/1/2017       3/31/2017         1              Feb 2017        1

1/1/2016      10/15/2017        10/1/2016   9/30/2017     1               1/1/2017       3/31/2017         1              Mar 2017        1

1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               4/1/2017       6/30/2017         1              Apr 2017        1

1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               4/1/2017       6/30/2017         1              May 2017        1

1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               4/1/2017       6/30/2017         1              Jun 2017        1

1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               7/1/2017       9/30/2017         1              Jul 2017        1

1/1/2016      10/15/2017        10/1/2016   9/30/2017     1               7/1/2017       9/30/2017         1              Aug 2017        1

1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               7/1/2017       9/30/2017         1              Sep 2017        1

1/1/2016       10/15/2017       10/1/2017   9/30/2018     1               10/1/2017     12/31/2017        1              Oct 2017        1

1/1/2016       10/15/2017       10/1/2017   9/30/2018     1               10/1/2017     12/31/2017        0              Nov 2017        0

1/1/2016       10/15/2017       10/1/2017   9/30/2018     1               10/1/2017      12/31/2017       0              Dec 2017        0

in this very small sample of my data, an employee starts employment 1/1/2016 and ends employment 10/15/2017.  I create the FYStart and FYEnd, QuartSt and QuartEnd, and MonYear on the load and determine the flag status based on the date ranges.  I want to create a chart where I can toggle between the FYview, the QuarterView and the monthly view, but it seems like it's disjointed?  how can I create one chart and toggle between?  currently I have 3 separate charts.

2 Replies
vinieme12
Esteemed Contributor II

Re: toggle between charts or drill down??

Re: toggle between charts or drill down??

Have a look at this ShowHide Container extension.

Qlik Branch