Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

How to restrict a combination of data set being shown in a p/table

Hi,

I need, to restrict a data set being shown in a pivot table where RF_MONTH=FROM_MONTH.

Thanks in advance

Neville

3 Replies
nevilledhamsiri
Specialist
Specialist
Author

nevilledhamsiri
Specialist
Specialist
Author

Hi Experts!

Appreciate if reference is made to wards this.

Thanks

Neville

sunny_talwar

May be this

Sum(If(MonthName(FROM_DATE) = MonthName(RF_DATE), VALUE))


Capture.PNG