Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Conditional calculation Qlik Sense

Hello all,

I have a table of activities in Qlik Sense displayed by month.

I just want the expression to be calculated by month ONLY when the month is selected. If not, I don't want to show this column in the table.

For example: if the user selects JANUARY, I Just want to show this month, not the others.

I think it is not possible with Sense because I can only put a condition in the whole object (table) not in each expression.

Thank you in advance.

Tags (1)
18 Replies
satishkurra
Valued Contributor II

Re: Conditional calculation Qlik Sense

May be this expression in calculated condition.

GetSelectedCount(Month) > 0

Here Month is your column name.

Not applicable

Re: Conditional calculation Qlik Sense

Yes, thanks, I have this one in the whole object (table).

But I need this condition by each month, because I have 12 columns and I want to show only those which are selected.

satishkurra
Valued Contributor II

Re: Conditional calculation Qlik Sense

Please share sample data or app

reddys310
Honored Contributor II

Re: Conditional calculation Qlik Sense

Hi Anna,

Try this in the set analysis of all your measures:

Example:

Sum({$< Month = {$(=GetFieldSelections(Month))} >} Sales)

tkendrick20
Valued Contributor

Re: Conditional calculation Qlik Sense

I don't think you can conditionally show an entire column in a table. However, I am doing something similar in one of my apps where I rename an existing column and show different data if a value is selected in field using IF(GetSelectedCount(field) > 0, **, **)

Not applicable

Re: Conditional calculation Qlik Sense

I have tried your suggestion but it did not work

Not applicable

Re: Conditional calculation Qlik Sense

This:

Capture.JPG

In this case I just want to show Enero because it is the only one selected

Not applicable

Re: Conditional calculation Qlik Sense

This is my script: I have data in months by columns and I had to make an inline table to link them:

[Sheet1]:

tabla1:

LOAD [Cod. Cambio],

  [Descripción],

  [Trabajador],

    If([Total Imputado]='',NULL(),[Total Imputado]) as [Total Imputado],

     If(Enero='' or Enero=0,NULL(),Enero) as Enero,

     If(Febrero='',NULL(),Febrero) as Febrero,

     If(Marzo='',NULL(),Marzo) as Marzo,

     If(Abril='' or Abril=0 or len(Abril)=0,NULL(),Abril) as Abril,

     If(Mayo='',NULL(),Mayo) as Mayo,

     If(Junio='',NULL(),Junio) as Junio, 

     If(Julio='',NULL(),Julio) as Julio, 

     If(Agosto='',NULL(),Agosto) as Agosto,

     If(Septiembre='',NULL(),Septiembre) as Septiembre, 

     If(Octubre='',NULL(),Octubre) as Octubre,

     If(Noviembre='',NULL(),Noviembre) as Noviembre,

     If(Diciembre='',NULL(),Diciembre) as Diciembre

FROM [lib://Desktop/Book3.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, RowCnd(Compound,

  RowCnd(CellValue, 1, StrCnd(null)),

  RowCnd(CellValue, 2, StrCnd(null)),

  RowCnd(CellValue, 3, StrCnd(null))

)),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null))

));

tabla2:

load *,

if(len([Cod. Cambio])<>0 and len(Descripción)<>0 and len(Trabajador)=0,'Total',Trabajador) as Trabajador2

resident tabla1;

drop table tabla1;

Mes:

load * inline [id, meses

1, Enero

2, Febrero

3, Marzo

4, Abril

5, Mayo

6, Junio

7, Julio

8, Agosto

9, Septiembre

10, Octubre

11, Noviembre

12, Diciembre

];

Not applicable

Re: Conditional calculation Qlik Sense

Hello Tim, this is my script and I show a imagen example also:

I have data in months by columns and I had to make an inline table to link them:

[Sheet1]:

tabla1:

LOAD [Cod. Cambio],

  [Descripción],

  [Trabajador],

    If([Total Imputado]='',NULL(),[Total Imputado]) as [Total Imputado],

     If(Enero='' or Enero=0,NULL(),Enero) as Enero,

     If(Febrero='',NULL(),Febrero) as Febrero,

     If(Marzo='',NULL(),Marzo) as Marzo,

     If(Abril='' or Abril=0 or len(Abril)=0,NULL(),Abril) as Abril,

     If(Mayo='',NULL(),Mayo) as Mayo,

     If(Junio='',NULL(),Junio) as Junio, 

     If(Julio='',NULL(),Julio) as Julio, 

     If(Agosto='',NULL(),Agosto) as Agosto,

     If(Septiembre='',NULL(),Septiembre) as Septiembre, 

     If(Octubre='',NULL(),Octubre) as Octubre,

     If(Noviembre='',NULL(),Noviembre) as Noviembre,

     If(Diciembre='',NULL(),Diciembre) as Diciembre

FROM [lib://Desktop/Book3.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, RowCnd(Compound,

  RowCnd(CellValue, 1, StrCnd(null)),

  RowCnd(CellValue, 2, StrCnd(null)),

  RowCnd(CellValue, 3, StrCnd(null))

)),

Replace(1, top, StrCnd(null)),

Replace(2, top, StrCnd(null))

));

tabla2:

load *,

if(len([Cod. Cambio])<>0 and len(Descripción)<>0 and len(Trabajador)=0,'Total',Trabajador) as Trabajador2

resident tabla1;

drop table tabla1;

Mes:

load * inline [id, meses

1, Enero

2, Febrero

3, Marzo

4, Abril

5, Mayo

6, Junio

7, Julio

8, Agosto

9, Septiembre

10, Octubre

11, Noviembre

12, Diciembre

];

Community Browser