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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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