Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How would I write Set expression for different criterias?

My formula is below, how would I write Set expression?

=((table1 expession/table2 expression)*1000*(#ofdays in year))/#ofdays in month field1

3 Replies
Not applicable
Author

On what do you need Set Analysis? Set analysis is analogus to WHERE in SQL.

Regards,

Kiran

Not applicable
Author

I'm filtering my variables in my expression in my pivot table.  I read that Set analysis was most efficient way to calculate.  I'm not sure how to write my formula using Set analysis syntax.

IAMDV
Luminary Alumni
Luminary Alumni

Hi,

Please can you post the sample QV App. with your original expression? Also, it will be good to give more details on what you wanted to acheive. I can work this one for you...

Cheers - DV