topic Re: Dimension without filters in QlikView

Dimension without filters

frank1982 — Fri, 06 Jul 2018 14:59:42 GMT

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:

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.

sunny_talwar — Fri, 06 Jul 2018 15:40:53 GMT

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

frank1982 — Fri, 06 Jul 2018 15:48:11 GMT

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

Thanks

sunny_talwar — Fri, 06 Jul 2018 15:56:52 GMT

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

frank1982 — Fri, 06 Jul 2018 16:11:43 GMT

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 :

This is the result I would like to have.

sunny_talwar — Fri, 06 Jul 2018 16:13:54 GMT

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)

frank1982 — Fri, 06 Jul 2018 16:19:38 GMT

Great!

It works!

Thank you very much Sunny!

You are the number one.