Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Small Query on Set Analysis

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

1 Solution

Accepted Solutions
martin59
Valued Contributor II

Re. :Small Query on Set Analysis

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 Replies
Not applicable

Small Query on Set Analysis

Hi,

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

martin59
Valued Contributor II

Re. :Small Query on Set Analysis

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

Highlighted
Not applicable

Re. :Small Query on Set Analysis

thanks Martin you saved by day

Not applicable

Re. :Small Query on Set Analysis

saved my day Embarrassed