Set Analysis

[Anonymous]

Guys,

When I select both month and year, the data should change for a particular object. It should not be changed when other dimensions are filtered. Plz help me out....

[MK_QSL]

May be something like below

=SUM({1<InvoiceMonth = $::InvoiceMonth, InvoiceYear = $::InvoiceYear>}Sales)

Change expression fields according to your application.

[Anonymous]

Thank you so much Manish...

[CarlosAMonroy]

Hi Siva,

Suppose you have 4 dimensions (Year, Month, Region and Country). If you only want data to chan ge when you make selections for Year, Month, try the following:

sum({<Region=, Country=>}Amount)

Hope it helps,

Carlos M

[Anonymous]

Thank you Carlos... I got it.

[MK_QSL]

If you have got answer, why you closed the thread by selecting Mark as assumed answered

If you think that either my answer or Carlos answer is correct, you should select our answer correct or helpful.

This will encourage members to give answers.

Qlik Community Tip: Marking Replies as Correct or Helpful