topic Re: Month trend with SET in QlikView

Month trend with SET

Sun, 16 Oct 2011 15:29:37 GMT

Hi,

I have the following set syntax and I use it for every month * 12

sum({ $<Month = {'Apr'}>} [Sales])

The problem I have is if i select Mars I would like to have 0 in the April and all the month ahead but have values in Jan til Mars columns

How could i solve that ?

Regards mikael

Sun, 16 Oct 2011 17:24:12 GMT

Hi Mikael, check this attached doc. is that what you're looking for....

Sun, 16 Oct 2011 20:44:00 GMT

Hi,

How could I use the syntax toghter with my different month columns ?

Regards mikael (-;

Mon, 17 Oct 2011 00:44:19 GMT

Hi mikael: check the attached doc....its a workaround.

Mon, 17 Oct 2011 20:25:04 GMT

Hi,

It works as I wanted but I see a problem in the layout.

I will have columns on the month I select - for exampel I select April I then will have the following columns

Jan, Feb, Mars and April (works fine) but I then need to have YTD this year and YTD last year.

How could I solve that ?

I think I must create seperat month columns and then have a statement that I will not show any value in the columns above the one I select.

exemple.

If I select month Feb I will have values on Jan and Feb and 0 on all the rest month colums.

Regards mikael