Quarter Vs Quarter Condition in Qlik sense Script

[UserID2626]

hi,

i am trying to implement Quarter vs Quarter in script and using it in Pivot table.

Below table is my requirement.

Adding a column manually in Pivot table is not possible,tried by duplicating columns as given in below link

https://community.qlik.com/t5/New-to-Qlik-Sense/MOM-column-in-Pivot-table-Qlik-Sense/m-p/1537782#M12...

Achieved my requirement, issue is when using month as filter and selecting a particular month(for eg:may), only Q2 column should reflect, but values in Q2VsQ1 and Q3VsQ2  column also showing(because may month is included in that Quarter).

if i use identifier one sum({1<Quarter condition>}amount) and selecting MAY month , also the values are showing same as above image.

i want to show the values in Q2vsQ1 and Q3VsQ2  zero if any selection made.

Attaching my app and sample.

Thanks...

[sreeramhbk · Accepted solution]

Hi,

Refer the below link:

https://community.qlik.com/t5/New-to-QlikView/Multiple-Alternate-States/m-p/611075.

Please refer the quarterly chart alone in the attached app. 

Thank you