topic Re: supress data conditionally in QlikView

supress data conditionally

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

Hi All,

I have the below straight table showing current and previous month sales.

In the expression showing previous month sales, i want to show only those sales when there is current month sales for that product, ie supress rows that has no sales in current month.

Please help!

Re: supress data conditionally

surajdhall — Wed, 06 Feb 2019 15:51:03 GMT

sorry missed highlighting the row.

Below highlighted row should be supressed from the chart.

Re: supress data conditionally

Gysbert_Wassenaar — Wed, 06 Feb 2019 16:10:55 GMT

Use this as the second expression:

If(sum({<MonthYear = {'$(vCurrentMnt)'}>}Margin)/
sum({<MonthYear = {'$(vCurrentMnt)'}>}Sales),
sum({<MonthYear = {'$(vPreviousMnt)'}>}Margin)/
sum({<MonthYear = {'$(vPreviousMnt)'}>}Sales)
)

Re: supress data conditionally

surajdhall — Thu, 07 Feb 2019 21:15:53 GMT

Thank you so much!