Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

deepaktibhe
Valued Contributor

Modifications on chart

Hi All,

PFA.

We have yearly data but on chart(on x axis) we have to show MAR-Yearname (Mar1990,Mar1991) but data should be yearly.

Can you please suggest on this

Thanks

7 Replies

Re: Modifications on chart

If you have Date Field in your Script, create MonthYear as below

Date(MonthStart(Date),'MMMYYYY') as MonthYear...

Now use below as calculated dimension in your chart

=Aggr(IF(WildMatch(MonthYear,'Mar*'),MonthYear),MonthYear)

Not applicable

Re: Modifications on chart

You do not have a Year colomn in your script? because that would be the easiest.

I suggest editing your script and add a Year Column.

deepaktibhe
Valued Contributor

Re: Modifications on chart

Hi Manish,

It is not working.

Thanks

deepaktibhe
Valued Contributor

Re: Modifications on chart

Hi Manish,,

After modifying script suggested by you I am able to see data only for march for all years.

When i click on other month it is showing blank.

Thanks

Re: Modifications on chart

Provide sample application...

Re: Modifications on chart

Hi,

After modifing script as suggested by Mr. Manish.

Just add MonthYear as your Dimension.

Regards

Regards,
Prashant Sangle
perumal_41
Valued Contributor II

Re: Modifications on chart

Hi Deepak,

change expression like below

 

=

Sum({<MonthYear={'Mar'}>}aggr(Nodistinct sum(Amount),Year))

Community Browser