Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis

Hi

i have problem in set analysis

my expression is

sum({<[GL Date]={">=$(=Start Period)"}>}[Net Amount])

here  Start Period  values are  periodstartdate,quarterstartdate,yearstartdate

all date fields are in timestamp format .

if im using expression like

sum({<[GL Date]={">=$(=periodstartdate)"}>}[Net Amount])

this expression working fine.

but problem with start period

how to use these type of values in setanalysis.

15 Replies
Not applicable
Author

hi

the Start Period is a Field then period,quarter and years is data ?

sujeetsingh
Master III
Master III

Please explain the outcome of your expression what you want.

jyothish8807
Master II
Master II

Try this,

sum({<[GL Date]={">=$(=[Start Period])"}>}[Net Amount])

Use a [ ] at Start Period.

Regards

Jyothish KC

Best Regards,
KC
Not applicable
Author

Hi

here start period values are period start date,quarter start date,year startdate,

these are also fileds

er_mohit
Master II
Master II

Try this

sum({<[GL Date]={'>=$(=Date([Start Period]))'}>}[Net Amount])

Not applicable
Author

Hi

i already try this,but this is also not working

here start period representing another field values

Not applicable
Author

i think the Start Period is Table name and the date,quarter and yearstartdate are field of Start Period ?

NavinReddy
Creator II
Creator II

sum({<[GL Date]={">=$(Start Period)"}>}[Net Amount])

remove '=' and try

tresesco
MVP
MVP

Please share your sample app.