topic Set Analyses in QlikView

Set Analyses

francisvandergr — Wed, 06 Jul 2011 14:01:32 GMT

I have a formula in a Straight table.

sum({ $ < Year = {$(#=only( Year2 ))}> } Sales)

I wanna compare 2 periods. I have four important fields for it :

Year

Month

Year2

Month2

Formula above works for Year2. When i select year2 in my dashboard, i see all sales of the selected period. Now i wanna extend my formula with month2.

It must be possible to selct more months.

Can someone help me with the formula incl. Month2.

Thnx

Francis

Set Analyses

Wed, 06 Jul 2011 14:09:37 GMT

All you should need to do is add the formula using a comma to seperate it. Therefore it should look something like this

sum({ $ < Year = {$(#=only( Year2 ))}> },{ $ < Month = {$(#=only( Month2 ))}> } Sales)

Regards

Set Analyses

francisvandergr — Thu, 07 Jul 2011 19:24:56 GMT

The easiest way to compare is with bookmarks in this way