topic Re: Separate bar in QlikView

Separate bar

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have a bar chart with all the quarters .

but my requirment is i want to show 2018Q4 2019Q1,2019Q2,2019Q3 and beyond 2019Q3 means 2019Q4 2020Q1 2020Q2 ...till last quarter as separate bar. as shown in image, !

in attached qvw - first sheet first chart i need to show like below.

Re: Separate bar

jyothish8807 — Mon, 24 Sep 2018 08:15:12 GMT

Hi Sony,

Sorry, i am not clear about your requirement, can you please explain again ?

Br,

Re: Separate bar

jyothish8807 — Mon, 24 Sep 2018 08:21:38 GMT

Hi Sony,

Check this:

Re: Separate bar

jyothish8807 — Mon, 24 Sep 2018 08:22:37 GMT

Re: Separate bar

Frank_Hartmann — Mon, 24 Sep 2018 09:02:46 GMT

and without Total in stacked Barchart check attached!

Re: Separate bar

soniasweety — Mon, 24 Sep 2018 10:39:19 GMT

thank you

franky_h79

jyothish8807 but " can we make this dynamic? bcz if i move to next quarter

again i need to change the calucalted dimension right?

how can w handle this?

Re: Separate bar

jyothish8807 — Mon, 24 Sep 2018 10:47:28 GMT

So what will be your expected labels in next quarter ?

Re: Separate bar

soniasweety — Mon, 24 Sep 2018 10:51:25 GMT

2019Q1 2019Q2 2019Q3 2019Q4 Beyond 2019Q4

Re: Separate bar

jyothish8807 — Mon, 24 Sep 2018 11:14:21 GMT

Try this:

=if(Fiscal_Period > Year(Addmonths(today(),9))&'Q'&ceil(month(Addmonths(today(),9))/3),'Beyond '& Year(Addmonths(today(),9))&'Q'&ceil(month(Addmonths(today(),9))/3),

if(Fiscal_Period>= Year(today())&'Q'&ceil(month(today())/3),Fiscal_Period))

As per the logic the dimension will start from 2018Q3 (Current Quarter) but you do not have data for this quarter, so it will start from 2018Q4

Br,

Re: Separate bar

soniasweety — Mon, 24 Sep 2018 11:21:59 GMT

thanks but as per my customer current quarter is 2018Q4 only ...

Re: Separate bar

jyothish8807 — Mon, 24 Sep 2018 11:24:37 GMT

Since you do not have data for 2018Q3, it will start from 2018Q4 only. So what will your customers current quarter in Jan 2019 ?

I am just trying to understand the logic.

Br,

Re: Separate bar

soniasweety — Mon, 24 Sep 2018 11:27:16 GMT

that i need to check .. and get back on this . as they shared the latest file in that they mentioned current quarter is 2018Q4

Re: Separate bar

soniasweety — Mon, 24 Sep 2018 11:31:40 GMT

just checked internally saying that Nov is the Q1 for the customer

[ need to check with bussiness]

so is there anything needs to chnge in caluclated dimension ?franky_h79

jyothish8807

Q1 starts from Nov

dec

jan

Feb ,mar ,aprl

may jun jul

aug sep oct

Re: Separate bar

soniasweety — Tue, 25 Sep 2018 04:44:35 GMT

Frank Hartmann

Jyothish KC

any update on this ?

Re: Separate bar

soniasweety — Tue, 25 Sep 2018 04:45:28 GMT

Hi felipedl‌

tresescocan you look into this?

Re: Separate bar

Frank_Hartmann — Tue, 25 Sep 2018 08:59:43 GMT

check attached qvw!

Re: Separate bar

soniasweety — Tue, 25 Sep 2018 09:05:59 GMT

thank you .. same question its dynamic right?

and instead of lengthy calucalted dimension can we place in variable and cant we use that in cal dimension?

Re: Separate bar

Frank_Hartmann — Tue, 25 Sep 2018 09:22:29 GMT

Yes it is dynamic.

See attached for variable use

Re: Separate bar

Frank_Hartmann — Tue, 25 Sep 2018 09:28:33 GMT

for dynamic check just change the systemtime of your pc. the chart should change accordingly!

Re: Separate bar

soniasweety — Tue, 25 Sep 2018 09:42:22 GMT

thank you so much sir,.. its working just give me sometime i will close this thread with correct answer !!