topic Re: Show current yr and last yr value on the same bar in App Development

Show current yr and last yr value on the same bar

QS21 — Wed, 19 Jan 2022 11:20:36 GMT

Hi all,

I need to create a bar chart on which I will have months Jan to Dec on X axis like this:

Jan, Feb, Mar,......., Dec

As for measures, I have Balance which I need to show as two bars. For example, on Jan, I will have two bars one will show curr year balance and other will show last year balance.

Please help me with how to achieve this in qliksense..

Thanks!

Re: Show current yr and last yr value on the same bar

chris_djih — Wed, 19 Jan 2022 12:31:02 GMT

have a look at @Patric_Nordstrom's christmas special:

https://community.qlik.com/t5/Qlik-Sense-Documents/24-days-of-Visualization/ta-p/1875069

i think the 2nd sheet (3 possible ways to do it) is what you need:

Re: Show current yr and last yr value on the same bar

QS21 — Fri, 28 Jan 2022 12:07:48 GMT

Hi @chris_djih ,

I tried opening the link but I coulnot find the article that you mentioned.. and yes, I am looking for something like above.. Request if you could post the same solution here. Many thanks in advance!

Re: Show current yr and last yr value on the same bar

chris_djih — Fri, 28 Jan 2022 12:44:04 GMT

You saw this image on the link?

Then you were on the right article, just scroll down and there you can find an example app and the explanation in the attachements:

There it is exactly described how to solve this in pages 4-9...

Re: Show current yr and last yr value on the same bar

QS21 — Mon, 31 Jan 2022 09:40:51 GMT

Hi Chris,

I have tried and achieved the same. I needed a bar chart with axis showing months Jan, Feb etc and on Jan I will show two bars one for curr mth and other for last mth. I was able to achieve this by using date o dimensions and year on dimension2.

Now the problem is I need to bring another chart same one but need to show YTDs. I have been trying for two days and there is no luck. I have used

If(num(month(date#(mydate,'mmmm')))<=num(month(date(mydate2))),

Rangesum(above((sum({<desc='www'}>}balance)/xrate),0,rowno()))/1000)

Pls help!

Re: Show current yr and last yr value on the same bar

chris_djih — Mon, 31 Jan 2022 13:26:51 GMT

I would recomment to add a field in your calender script (if exists), or at least a new date field that makes selection for YTD a lot more easier:

Load *, IF(NUM(NUM(Month(DateField),'00') & NUM(Day(DateField),'00')) <= NUM(Month(today()),'00') & NUM(Day(today()),'00'),1,0) AS Date_YTD resident table;

then you can add this field into a set-analysis: {<Date_YTD={1}>}.