Solved: Re: If condition - Qlik Community

dhruvipanchal88 · ‎2022-02-22

Hi,

In visualization, I wanted to show only Q1 data in table 1 and similar way Q2 data in table 2 in one sheet.

Can anyone suggest formula?

Dhruvi

MarcoWedel · ‎2022-02-22

MarcoWedel · ‎2022-02-22

Iswarya_ · ‎2022-02-22

You can use set analysis in the measure and filter the data needed

table 1 for Q1: Jan-Mar

Sum({<Date={">=$(=QuarterStart(YearStart(Today(),0,1))) <=$(=QuarterEnd(YearStart(Today(),0,3)))"}>}[Nett Amount new EUR])

table 2 for Q2: Apr-June

Sum({<Date={">=$(=QuarterStart(YearStart(Today(),0,4))) <=$(=QuarterEnd(YearStart(Today(),0,6)))"}>}[Nett Amount new EUR])

dhruvipanchal88 · ‎2022-02-24

It worked. Thank You

Iswarya_ · ‎2022-02-24

If the issue is solved please mark the answer with Accept as Solution.

MarcoWedel · ‎2022-02-24

glad it worked.

please close your thread by accepting a solution.

thanks

If condition