Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Master II
Master II

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