topic Re: show dimension in chart in QlikView

show dimension in chart

narender123 — Wed, 03 Feb 2016 09:44:28 GMT

Hi All,

I have to show column in a table like.

Name date of arrival Agent Rotation

A 1/1/2016 RAMS LTD. 140

B 1/5/2016 VIRAJ LTD. 370

i dont need any calculation but want to show only dimension .

Note: I have to show current month of current year clumns only.So i cant use table box to set current year moth.

Thanks,

Narender.

Re: show dimension in chart

sunny_talwar — Wed, 03 Feb 2016 09:47:49 GMT

If you can create them in script then you can create a table box. Else use a straight table.

Dimension can be Name, Agent, Rotation and then expression can be Month([date of arrival]) and Year([date of arrival])

Re: show dimension in chart

PrashantSangle — Wed, 03 Feb 2016 09:50:10 GMT

Hi,

Why you dont required any expression??

To achieve your requirement

take straight table

add required dimension and then go to property -> Presentation ->untick supress zero values and untick supress missing.

Re: show dimension in chart

narender123 — Wed, 03 Feb 2016 10:04:16 GMT

Hi Max Dreamer,

I have to show only current month year records.

Thanks for the reply,

Narender

Re: show dimension in chart

sunny_talwar — Wed, 03 Feb 2016 10:05:49 GMT

Make a selection in current MonthYear to see just those entries for current monthyear in the table box?

Re: show dimension in chart

narender123 — Wed, 03 Feb 2016 10:07:17 GMT

Hi Sunny,

In Expression .Both month and year together no working.

Only single is working means month only or we can say year only.

=max(year([RECEIPT_DATE]))and max(Month([RECEIPT_DATE])) not working.

=max(year([RECEIPT_DATE])) working.

Thanks,

Narender

Re: show dimension in chart

PrashantSangle — Wed, 03 Feb 2016 10:11:07 GMT

Hi,

You can achieve it by creating current Month Field either in script or in chart by calculated dimension.

Calculated Dimension like

if(Month(Date_Field)=Month(Today()),Date_Field)

and also tick supress null from dimension tab.

Note :

Calculated dimension is not recommended due to Performance issue.

Regards

Re: show dimension in chart

sunny_talwar — Wed, 03 Feb 2016 10:12:05 GMT

If you want to see MonthYear, I guess use MonthName() function which displays as MMM YYYY.

Max(MonthName([RECEIPT_DATE]))

MonthName(Max([RECEIPT_DATE]))

Re: show dimension in chart

narender123 — Wed, 03 Feb 2016 10:45:53 GMT

Hi Sunny,

Thanks you so much.

Its working.Now all records of feb 2016 is showing. Can we hide this expression means hide exression but showing current year month just like its showing records now .

Please suggest.

Re: show dimension in chart

sunny_talwar — Wed, 03 Feb 2016 10:49:04 GMT

In a straight table? Yes you can. Go to presentation tab and select the expression label for the above expression and click Hide Column

Re: show dimension in chart

narender123 — Wed, 03 Feb 2016 10:55:57 GMT

Got it.

Thanks,

Narender.