Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
stalwar1
Not applicable

Re: getting problem with Only Function

May be this:

Alt(

If(GetSelectedCount(Quarter)=0,

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

Count(Fdbk_Typ)), 0)