Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Previous Year Only but until current month of previous year

Hi All,

Wonder if you can help me:

I want to create a chart/table where i can show previous fiscal year sales and current fiscal year sales in bar chart.

The trouble is current fiscal year is only till sept and previous fiscal year shows till december of this year.

I want the chart to show the sales of previous year only until the current month of previous year. My year starts from May.

below is the example of the chart. Can someone help please?

Basically we dont want to see data in previous fiscal year month until there is a date in the actual fiscal year.

 

MonthActualPrevious Year
May120200
Jun130150
Jul140170
Aug150380
Sep0100
Oct0450
Nov0220
Dec0120
Jan0360
Feb0200
Mar0130
Apr0470
1 Solution

Accepted Solutions
sunny_talwar

May be this?

Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order)-1)}, Month = {"=Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order))}>}[Amount]) > 0"}>}[Amount])

Capture.PNG

View solution in original post

4 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

Let's see if this addresses your issue:

Capture.PNG

Use set analysis to filter out the actual number greater than zero.

Hope this helps.

Not applicable
Author

Hi Sinar,

that doesn't work.

Attached is the app

Can you help on this?

Regard

sunny_talwar

May be this?

Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order)-1)}, Month = {"=Sum({$<Year_Fiscal_Order = {$(=Max(Year_Fiscal_Order))}>}[Amount]) > 0"}>}[Amount])

Capture.PNG

Not applicable
Author

Sunny,

You are a legend. I am out of words to thank you.

Can you also try and help on this as well if you can?

Re: Previous Fiscal Year data does not show up when i select date from calendar

Regards,

Sarb