Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

businessintelli
New Contributor III

Re: Year comparison in bar chart

I cant

MVP
MVP

Re: Year comparison in bar chart

Mock up data my friend...

businessintelli
New Contributor III

Re: Year comparison in bar chart

It's okay.

Can I use this formula in bar chart like this?

28309995_2064236076950054_2098739438_o.jpg

In January second chart should be current year and  first chart should be the previous and it will show the sum for the same companies. But in this case I have 3years and I want to show all of them in all months'. I also want to have drill down  on them. When I select January , all dates  of the january should be shown and every date should have the comparison chart to the previous date( as it was in months)

MVP
MVP

Re: Year comparison in bar chart

I believe it should work, but I am new to Qlik Sense too... may be omarbensalem‌ can offer his expertise here

businessintelli
New Contributor III

Re: Year comparison in bar chart

Sorry for disturbing you again, but can you tell me where should I add {1-$} in the formulas that you told me to ignore all current selections?

And thanks a lot !!! I really appreciate your help!!

MVP
MVP

Re: Year comparison in bar chart

In this one?

=Sum({$<Date = {">=$(=YearStart(Today()))<=$(=MonthEnd(Today()))"}>} FactSoldAmount)


=Sum({$<Date = {">=$(=YearStart(AddYears(Today(), -1)))<=$(=MonthEnd(AddYears(Today(), -1)))"}, Company = p({<Date = {">=$(=YearStart(Today()))<=$(=MonthEnd(Today()))"}>})>}FactSoldAmount)


=Sum({$<Date = {">=$(=YearStart(AddYears(Today(), -2)))<=$(=MonthEnd(AddYears(Today(), -2)))"}, Company = p({<Date = {">=$(=YearStart(Today()))<=$(=MonthEnd(Today()))"}>})>}FactSoldAmount)

May be here (I believe that just {1} should be enough not sure why you need {1-$}...

=Sum({1<Date = {">=$(=YearStart(Today()))<=$(=MonthEnd(Today()))"}>} FactSoldAmount)


=Sum({1<Date = {">=$(=YearStart(AddYears(Today(), -1)))<=$(=MonthEnd(AddYears(Today(), -1)))"}, Company = p({1<Date = {">=$(=YearStart(Today()))<=$(=MonthEnd(Today()))"}>})>}FactSoldAmount)


=Sum({1<Date = {">=$(=YearStart(AddYears(Today(), -2)))<=$(=MonthEnd(AddYears(Today(), -2)))"}, Company = p({1<Date = {">=$(=YearStart(Today()))<=$(=MonthEnd(Today()))"}>})>}FactSoldAmount)

businessintelli
New Contributor III

Re: Year comparison in bar chart

Yes , it works .And if I want to ignore only the year and month?  I tried to write {1} only before the first date  but it seems I'm incorrect

Highlighted
MVP
MVP

Re: Year comparison in bar chart

Replace 1 with <Year, Month>

businessintelli
New Contributor III

Re: Year comparison in bar chart

Hello  

I have one question regarding this issue. I want to have climber selection bar where I can see the Companies in the years that I select.  I use the formulas that you told me in the bar chart and it works well.

=Sum({$<Year,Date = {">=$(=YearStart(Today()))<=$(=MonthEnd(Today()))"}>} FactSoldAmount)

=Sum({$<Year, Date = {">=$(=YearStart(AddYears(Today(), -1)))<=$(=MonthEnd(AddYears(Today(), -1)))"}, BranchID = p({<Year = {"$(=Max(Year))"}>})>} FactSoldAmount)

=Sum({$<Year, Date = {">=$(=YearStart(AddYears(Today(), -2)))<=$(=MonthEnd(AddYears(Today(), -2)))"}, BranchID = p({<Year = {"$(=Max(Year))"}>})>}FactSoldAmount)


In the climber bar I have company in dimension and it shows me all companies. But I want to show only the companies in these years.  And when I click years it works well. Can you help me ?

MVP
MVP

Re: Year comparison in bar chart

Climber bar? I am not sure I know what that is