Small Query on Set Analysis

[#1]

Hi,

I have a very simple query on Set Analysis. Pls have a look at the attached QV file. What I want to do in a chrt is that when I select a Quarter the first charts shows the data for the quarter and the second shows the data for the previous quarter.

When I do the same for Years the charts work, but somehow for the quarters they don't work.

Help much appreciated thanks

[#2]

Hi,

You can not do this same with year because quarteryear field is not numeric.

[martin59 · Accepted solution]

Hi,

You can not make a substraction on your QuarterYear field, it is necessary to decompose your text field.

look the attached QV file.

Regards,

Martin

[#4]

thanks Martin you saved by day

[#5]

saved my day