topic Re: Chart Help in QlikView

Chart Help

nagarjuna_kotha — Wed, 04 Nov 2015 10:09:02 GMT

Hi All,

I want to know small thing I have chart like below.

In dimension i have QuarterYear.In below chart I want to remove Q1 11, Q2 11, Q3 11, Q4 11.

How to remove only those .

Re: Chart Help

Wed, 04 Nov 2015 10:11:56 GMT

send that qvw file it would be better

Re: Chart Help

Anonymous — Wed, 04 Nov 2015 10:12:44 GMT

depending of your dateformat you shoud use a calculated Dimension

dateformat

if (year(yourquarterfield) > 2011, yourquarterfield)

stringformat

if (right(yourquarterfield,2) <> '11,yourquarterfield)

Re: Chart Help

Anonymous — Wed, 04 Nov 2015 10:13:52 GMT

First thing, its not clear what you want to remove, Q1 or 11??

If you want to remove 11 from Q1

then try:

mid(QuarterYear,1,2) as QuarterYear // it wud give you Q1

Re: Chart Help

Gysbert_Wassenaar — Wed, 04 Nov 2015 10:13:52 GMT

The easiest way is to select the other values. If you want to do that only to this chart and not other charts in your document you can modify your expressions to exclude these specific values. For example Sum(Sales) would become Sum({<QuarterYear -= {'Q1 11','Q2 11','Q3 11','Q4 11'}>}Sales).

Re: Chart Help

prma7799 — Wed, 04 Nov 2015 10:15:33 GMT

Hi Nagarjuna,

Copy..............

How to use English color....

Re: Chart Help

MarcoWedel — Wed, 04 Nov 2015 21:42:37 GMT

Hi,

another solution could be:

=Sum({$<QuarterYear={"=Year(QuarterYear)>2011"}>} Value)

hope this helps

regards

Marco