Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Unite two charts

Hi!

I need to unite two charts into one, so that two columns will be next to each other by month.

Data for 1st graph: DATE(MONTHSTART([ZSLM_E020_MNDTM.Принято на поддержку]), 'MMM')

Measure:Count([Номер изменения])

Data for 2nd graph: DATE(MONTHSTART([ZSLM_E020_MNDTM.Регистрация завершена]), 'MMM')

Measure:Count([Номер изменения])


I don't understand how to write one function date(monthstart()) for two fields.


Thank you for your help!

Screenshot_3.png

7 Replies

Re: Unite two charts

I think you will need to add a canonical calendar here in the script and use flags in your expressions:

Canonical Date

galax_allu
Valued Contributor

Re: Unite two charts

Hi ,

why don't you try  to add multiple dimensions ?

Re: Unite two charts

I doubt that will work here, but can be tried

Not applicable

Re: Unite two charts

it doesn't work(

Not applicable

Re: Unite two charts

Hello!

The result there- is what I exactly need.

I still don't understand how to write script in my situatiaon, because i have all my data in one table, but i will try one more time tommorow.

Not applicable

Re: Unite two charts

Hi!

So I just need to unite in DataBridge 3 fields.

[ZSLM_E020_MNDTM.Регистрация завершена] and [ZSLM_E020_MNDTM.Принято на поддержку] : fields with dates, months, years

[Номер изменения] - this field i need to count


But do i need to create a new table, if all this fiels are in one table right now?

Load [ZSLM_E020_MNDTM.Регистрация завершена], [ZSLM_E020_MNDTM.Принято на поддержку] as CannonicalDate

And what is about DataType?

Thanks!



Not applicable

Re: Unite two charts

[Номер изменения]2[ZSLM_E020_MNDTM.Принято на поддержку]:

Mapping Load distinct [Номер изменения],[ZSLM_E020_MNDTM.Принято на поддержку] Resident [ZSLM_E022_MNDTM] ;

[Номер изменения]2[ZSLM_E020_MNDTM.Принято на поддержку]:

Mapping Load distinct [Номер изменения],[ZSLM_E020_MNDTM.Регистрация завершена] Resident [ZSLM_E022_MNDTM] ;

[DataBridge]:

Load [Номер изменения], ApplyMap('[Номер изменения]2[ZSLM_E020_MNDTM.Принято на поддержку]',[Номер изменения],Null()) as Cannoncaldate, 'Реализовано' as DataType

Resident [ZSLM_E022_MNDTM];

Load [Номер изменения], ApplyMap('[Номер изменения]2[ZSLM_E020_MNDTM.Регистрация завершена]',[Номер изменения],Null()) as Cannoncaldate, 'Зарегистрировано' as DataType

Resident [ZSLM_E022_MNDTM];

this doesn't work

Community Browser