Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Champion III
Champion III

try below

Period Presets: Compare Periods on the fly

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Have a look at this ShowHide Container extension.

Qlik Branch