Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

getting problem with Only Function

Hi Folks,

I have a data, for that i want to show Previous Quarter Data.

Measure Expr:-

If(GetSelectedCount(Quarter)=0,

Count({<QuarterNo={$(=Max(QuarterNo-1))}>}Fdbk_Typ),

Count(Fdbk_Typ))

Header Expr:-

'Total Survey Response' &' ' &

If(GetSelectedCount(Quarter)=0,

Only({<QuarterNo={$(=Max(QuarterNo-1))}>} Quarter),

GetFieldSelections(Quarter))

Its showing only data available Quarter. As below attached "Samsung " don't have data for Previous Quarter. So simply i want to show as 0.

Can any one help wit this..

Sub2u444

1 Reply
sunny_talwar

May be this:

Alt(

If(GetSelectedCount(Quarter)=0,

Count({<QuarterNo={$(=Max(QuarterNo-1))}>}Fdbk_Typ),

Count(Fdbk_Typ)), 0)