how to write a set expression for sales in current year and not in previous year?

[#1]

Hi All ,

how to write a set expression for sales in current year and not in previous year?

Thanks

John

[simonc-cfn]

Indirect Set Analysis

Set analysis was previously restricted to stating direct selections in a

field.

Starting with version 9, it is now possible to state selections in a field

based on selections in another field.

The functions p() and e() can be used to select the set of possible or

excluded values within a field.

Please see the attached imaged for additional details.

[jonasheisterkam]

Hi John,

it is not that easy to explain, it helps a lot to know how qlikview reduce the analyse data room by dimensions and selections. Set analysis is the way to generate selections additional to user interaction and calculate between different selection result dataset rooms. Here is a helpful generator if you not need set analysis that often. It helps with the syntax. Set Analysis Wizard for QlikView

[#4]

Thanks for your response .

Sorry Ishfaque Ahmed this is not my requirement.