Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
abhinavbose
Creator III
Creator III

Set Analysis

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

5 Replies
MK_QSL
MVP
MVP

May be something like below

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

Change expression fields according to your application.

abhinavbose
Creator III
Creator III
Author

Thank you so much Manish...

CarlosAMonroy
Creator III
Creator III

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

abhinavbose
Creator III
Creator III
Author

Thank you Carlos... I got it.

MK_QSL
MVP
MVP

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