Selecting data in table box

[#1]

There are daily data for 2 years.

I get the recent 1 month data and dispay at the chart at the first loading.(i.e. date with 20150501~20150531)

It is done by using set operations.

And want to show detail corresponding data(20150501~20150531)  in TABLE BOX but it shows all data at first loading.(all 2 years).

I did everything to do it but it was impossible cause I am a QV beginner.

Please help me.

[#2]

the set operation is

=Sum({<Date = {"$(='>=' & Date(Max(Date) - 30, 'YYYYMMDD') & '<=' & Date(Max(Date), 'YYYYMMDD'))"}>}Sales

[settu_periasamy]

Hi,

Try this

=Sum({<Date={">=$(=Date(Max(Date)-30),'YYYYMMDD')<=$(=Date(Max(Date),,'YYYYMMDD'))"}>}Sales)

[sujeetsingh]

Try using Calculating condition for the Table box and write down the Expression as Year >= and Year <

[shawn-qv]

To filter and display your data using Set Analysis, you will need to use a Chart (i.e. Pivot/Straight Table).

A Table Box will not allow you to use Expressions.

S.

[#6]

hi,

no calculation done in table box. here you can show only raw data .

use straight table for that.

Regards

Vimlesh