topic Re: Merge Month+Year in QlikView

Merge Month+Year & Show Trends

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

Hey Community,

I want to show value via chart that my dim is split to Month + Year Base on my field, but he dont shoe me noting.

i try Month(API2.DATE) + '/' + Year(API2.DATE).

i try to change the type on the script also, i will be happy if you can take a look at my app

David

Re: Merge Month+Year

sunny_talwar — Tue, 17 May 2016 09:09:31 GMT

Can you try this:

Date(MonthStart(API2.DATE), 'MMM/YYYY')

Re: Merge Month+Year

Anonymous — Tue, 17 May 2016 09:10:55 GMT

Its show the group by Month + Year but as you can see in my app the pic also show all the value per day its like a Trends

Re: Merge Month+Year

sunny_talwar — Tue, 17 May 2016 09:12:33 GMT

Oh, I see what you mean. I am still trying to figure out how we can do this. May be swuehl‌ or gwassenaar‌ can help us

UPDATE: I know using continuous might work, but not sure how exactly to get each month/year

Re: Merge Month+Year

Anonymous — Tue, 17 May 2016 09:12:35 GMT

try

date(API2.DATE,'MM/YYYY')

Re: Merge Month+Year

Anonymous — Tue, 17 May 2016 09:19:10 GMT

Now you see that its show sum of the value and not Trends

Re: Merge Month+Year

sunny_talwar — Tue, 17 May 2016 09:36:56 GMT

How about this?

Re: Merge Month+Year

sunny_talwar — Tue, 17 May 2016 09:37:58 GMT

The problem is when you make selections, then it won't behave as you would want.

Re: Merge Month+Year

swuehl — Tue, 17 May 2016 09:38:00 GMT

You can try with a continouus axis or hiding some of your date dimension values using a calculated dimension, something like

=Aggr(

If(MonthName(API2.DATE)<>Above(MonthName(API2.DATE)),

dual(MonthName(API2.DATE),API2.DATE),

Dual(' ',API2.DATE)

)

, API2.DATE)

In both cases, you might get trouble to show all month and correct date range, depending on the number of data points and the internal formatting logic using a continouus axis.

Attached a sample with the calculated dimension

Re: Merge Month+Year

swuehl — Tue, 17 May 2016 09:44:27 GMT

Attached another version using a continuous axis.

You may notice the issues I've mentioned when changing the date range.

Re: Merge Month+Year

Anonymous — Tue, 17 May 2016 10:50:38 GMT

stalwar1‌ swuehl

Thank you guys so much for your time and help i will play from here whit this

Re: Merge Month+Year

Anonymous — Tue, 17 May 2016 10:52:36 GMT

i see but this is very good work i will try to use filters for the date.