Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

frank1982
New Contributor III

Dimension without filters

Hi,

I need to develop a table with a text dimension (called CD_INDICE_M) that doesn't have to keep into consideration the filter for this field.

This is my dashboard:

  • Field's values of CD_INDICE_M

Filter.png

  • Table

Tabella.png

I try to write the Dimension using this syntax : =Only({1}CD_INDICE_M), but it doesn't work.

(Ora1,Ora2....Ora24 are expressions)

Someone could you help me?

Thank you in advance.

1 Solution

Accepted Solutions

Re: Dimension without filters

Try this

=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}, CD_INDICE_M>} N_VALORE_1_MGP-N_VALORE_1_MI1)

View solution in original post

6 Replies

Re: Dimension without filters

May be add {1} or {<CD_INDICE_M>} to all your expression's set analysis

frank1982
New Contributor III

Re: Dimension without filters

I'm sorry, but I don't understand, could you write the formula I should insert into the calculated Dimension?

Thanks

Re: Dimension without filters

You mentioned Ora1... Ora2.. Ora.... are expression what exactly is the expression? Can you share the expression behind one of them?

frank1982
New Contributor III

Re: Dimension without filters

Yes, sure, this is the formula of the Expression Ora1:


=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}>}N_VALORE_1_MGP-N_VALORE_1_MI1)


vDataA and vDataDA are variables of input.

Anywhere, if I don't filter the field CD_INDICE_M my table is :

Tabella_NoFiltro.png

This is the result I would like to have.

Re: Dimension without filters

Try this

=Avg({<DT_DATA_M={">=$(=Date(vDataDA,'DD/MM/YYYY'))<=$(=Date(vDataA,'DD/MM/YYYY'))"}, CD_INDICE_M>} N_VALORE_1_MGP-N_VALORE_1_MI1)

View solution in original post

frank1982
New Contributor III

Re: Dimension without filters

Great!

It works!

Thank you very much Sunny!

You are the number one.