Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Amareswarreddy
Contributor
Contributor

Requirement on vizlib combo chart.

Hi Team,
Requirement- we have to include bars for all months and a aggregated bar for current fiscal year in vizlibcombo chart and fiscal month starts from april

My expression for dimension :

if(Month(Month_Year) >= 4 and Year(Month_Year) = Year(Today()),
if(Month(Month_Year) <= Month(Today()) and Year(Month_Year) = Year(Today()),
'FY ' & Right(Year(Month_Year), 2) & 'YTD ' ,
Month(Month_Year)
),
Month(Month_Year) & ' ' & Year(Month_Year)
)

Output is as attached.

But we also need bars for April and May 2023.

Can anyone suggest how to achieve the above requirement.
Thanks in advanceWhatsApp Image 2023-06-14 at 1.28.40 PM.jpeg

Labels (2)
1 Reply
Alan_Slaughter
Support
Support

Hi Amareswar,

I would suggest contacting Vizlib support, for your questions with Vizlib.
https://community.vizlib.com/support/home