Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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

1 Solution

Accepted Solutions
Highlighted
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
Highlighted
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