Display the selected values

[Ramu_i]

Hi All,

I have Month and Quarter filters are there , 

If select the month it will display the selected month values like

If I select the jan it will display the 'jan' month,

If I select the May month it will display the  ' Jan,Feb, Mar, Apr, May'

If I Q1--Q1

If Q3--- Q1, Q2, Q3. 

Please help on that 

Advance thanks 

Ram

[anat]

U want to display values in chart ? 

[Ramu_i]

Hi Anat,

I am trying find the rolling sum in KPI, If I select the values in Month or quarter it will display the selected values,

If lable wise it will work, same logic is implemented in Set analysis.

---- we need variance also like compare with  current vs previous of same date .

If select the Q3 it will display the 2021 Q1,Q2, Q3 compare with , 2020 Q1,Q2,Q3 values.

Now Q4 is there , So data is only Up to Nov ,  it will compare the last of Jan to Nov data.

Thanks 

Ram

[sasikanth]

HI, 

try below exp

=sum({<Date= {">=$( =YearStart(max(Date))) <= $( = (max(Date))) "}>} Sales)

[abhijitnalekar]

Hi @Ramu_i,

You can use the below expression  

Current Year :

sum({<IDate={$("='>=' & Date(YearStart(Max(IDate)), 'MM/DD/YYYY') & '<=' & Date((Max(IDate)), 'MM/DD/YYYY')")}>}Sales)

Previous Year:

sum({<IDate={$("$(='>=' & Date(YearStart(Max(InvoiceDate),-1), 'MM/DD/YYYY') & '<=' & Date(addyears(Max(InvoiceDate),-1), 'MM/DD/YYYY'))")}>}Sales)

[Ramu_i]

Hi Sasikanth,

I tried , but this is not working,

I have Year, Month, Quarter fields are there and Date field also is there.

thank you 

Ram

[Chanty4u]

can you attach sample? 

or what is not working for you?  can you show something which is not working ?

you can try below link .

https://community.qlik.com/t5/QlikView-App-Dev/Jan-to-till-selected-months-data-should-display/m-p/4...