Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

Quarter Vs Quarter Condition in Qlik sense Script

hi,

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

Below table is my requirement.

Capture.PNG

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).

image.jpg

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...

Labels (3)
1 Solution

Accepted Solutions
sreeramhbk
Contributor III
Contributor III

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

View solution in original post

1 Reply
sreeramhbk
Contributor III
Contributor III

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