Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

aggr()

=count({$< [Cost Transaction Date] = {"<=$(=date('2017-11-30','MM/DD/YYYY'))>=$(=date('2017-11-01','MM/DD/YYYY'))"},

[Operation Code] = {'a','b'},

LinkId = {'OPSJ'}

>}[Cost Transaction )

The program above returns 333 rows of data



Count({$< [Cost Transaction Date] = {"<=$(=date('2017-11-30','MM/DD/YYYY'))>=$(=date('2017-11-01','MM/DD/YYYY'))"}

Aggr(sum({$< [Cost Transaction Date] = {"<=$(=date('2017-11-30','MM/DD/YYYY'))>=$(=date('2017-11-01','MM/DD/YYYY'))"},

[Operation Code] = {'a','b'},

>}[Cost Transaction ]) , (job code))


The program above returns 353 rows of data. So basically those 2 program are very 'similar' . What I dont understand is why the 2nd program returns 353 rows.


Could someone help me out ? thank you



2 Replies
Highlighted

You have not made any selection in Operation Code, have you?

Highlighted
Contributor
Contributor

I dont think that 's the problem.