topic Re: Modifications on chart in QlikView

Modifications on chart

deepakqlikview_123 — Tue, 14 Apr 2015 08:26:43 GMT

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

MK_QSL — Tue, 14 Apr 2015 08:34:53 GMT

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)

Tue, 14 Apr 2015 08:35:22 GMT

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.

deepakqlikview_123 — Tue, 14 Apr 2015 08:53:24 GMT

Hi Manish,

It is not working.

Thanks

deepakqlikview_123 — Tue, 14 Apr 2015 08:59:56 GMT

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

MK_QSL — Tue, 14 Apr 2015 09:07:29 GMT

Provide sample application...

PrashantSangle — Tue, 14 Apr 2015 09:11:20 GMT

Hi,

After modifing script as suggested by Mr. Manish.

Just add MonthYear as your Dimension.

Regards

perumal_41 — Tue, 14 Apr 2015 09:27:33 GMT

Hi Deepak,

change expression like below

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