Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

How would I write Set expression for different criterias?

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

Regards,

Kiran

Not applicable

How would I write Set expression for different criterias?

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
Honored Contributor II

How would I write Set expression for different criterias?

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

Community Browser