Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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