topic Re: Set Analysis in QlikView

Set Analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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....

Re: Set Analysis

MK_QSL — Wed, 25 Jan 2017 13:30:20 GMT

May be something like below

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

Change expression fields according to your application.

Re: Set Analysis

Anonymous — Wed, 25 Jan 2017 13:38:06 GMT

Thank you so much Manish...

Re: Set Analysis

CarlosAMonroy — Wed, 25 Jan 2017 13:40:24 GMT

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

Re: Set Analysis

Anonymous — Wed, 25 Jan 2017 13:44:10 GMT

Thank you Carlos... I got it.

Re: Set Analysis

MK_QSL — Wed, 25 Jan 2017 13:54:14 GMT

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