topic Re: Selecting data in table box in QlikView

Selecting data in table box

Thu, 25 Jun 2015 01:37:05 GMT

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.

Thu, 25 Jun 2015 01:55:19 GMT

the set operation is

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

settu_periasamy — Thu, 25 Jun 2015 03:53:07 GMT

Hi,

Try this

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

sujeetsingh — Thu, 25 Jun 2015 04:26:50 GMT

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

shawn-qv — Thu, 25 Jun 2015 04:28:59 GMT

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.

Thu, 25 Jun 2015 04:37:12 GMT

hi,

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

use straight table for that.

Regards

Vimlesh