topic Re: Table calculation condition in QlikView

Table calculation condition

danosoft — Mon, 12 Mar 2018 13:42:57 GMT

Hi i have a Table with my rows, i want in it make a condition when i select che month connect to it (The month i choice is the field MESEFINEFORN)

When i click on my choice MESEFINEFORN i want the table will be filter for it, and all is good, is simple..... but in the same time i want my table will be filter for this condition: D_FINE_VAL>D_FINE_FORN (are two dates

so i set in my calculation condition this: =GetFieldSelections(D_FINE_VAL)>GetFieldSelections(D_FINE_FORN)

but i see this is not function..... like you see in the picture, where is the fault?

Re: Table calculation condition

danosoft — Mon, 12 Mar 2018 16:55:22 GMT

Nobody can help me? Is impossible to do that in QlikView? how to filter a table OR a chart in this way?

Thanks

Re: Table calculation condition

Digvijay_Singh — Mon, 12 Mar 2018 20:19:06 GMT

Try this in your measure expression -

Sum({<D_FINE_VAL={"=D_FINE_VAL>D_FINE_FORN "}>}Sales)

Sum(if(D_FINE_VAL>D_FINE_FORN,Sales)) - But this will be slower than set analysis one

Re: Table calculation condition

danosoft — Tue, 13 Mar 2018 08:46:17 GMT

Hi thanks you for your reply, but i see when i put the expression, it not change the result; i attach there a file .xls so you can try do make an example.

I put the expression, like you see in the image, but nothing.....

Re: Table calculation condition

jonathandienst — Tue, 13 Mar 2018 09:15:05 GMT

I am not sure if I have completely understood your issue, but it looks to me like you are using the incorrect object. A Table Box allows not calculations - it simply displays the distinct combinations of the selected fields. The calclation condition (Condizione di Calcolo) determine whether the table as a whole is generated. This is usually used to prevent runaway and costly generation of huge tables.

You probably need a straight or pivot table. Choose a set of dimensions and then place the conditions in the measurements. Something like

Sum(If(D_FINE_VAL>D_FINE_FORN, AMOUNT))

Sum({<ACCOUNT = {"=D_FINE_VAL>D_FINE_FORN"} >} AMOUNT)

Note that you will need to edit the above examples for your particular requirements.

Re: Table calculation condition

danosoft — Tue, 13 Mar 2018 11:27:15 GMT

ah i think i understand.... but if i need to do this kind of expression?

D_FINE_VAL<= D_FINE_FORN and contemporary time D_FINE_VAL = Max of the Month i choice in selection?

the month i choice in selection is the month extract from the field D_FINE_VAL

Re: Table calculation condition

jonathandienst — Tue, 13 Mar 2018 11:53:05 GMT

>> but if i need to do this kind of expression?

Hard to say without more information.

>>D_FINE_VAL<= D_FINE_FORN and contemporary time D_FINE_VAL = Max of the Month i choice in selection?

Not sure what you mean here, I am afraid.

Can you create a small sample qvw document with some representative data and the table you want restricted?

Re: Table calculation condition

danosoft — Tue, 13 Mar 2018 13:11:40 GMT

not be afraid 🙂

i want to do an expression like this:

D_FINE_VAL<= D_FINE_FORN and in same time D_FINE_VAL = Max of the Month i choice in selection

i know for first expression i can do some like this:

Sum({<D_FINE_VAL={"=D_FINE_VAL<=D_FINE_FORN "}>}CONSUMO_TOT_ANNUO)

i wanna add to that the: D_FINE_VAL = Max(of the Month i choice in selection)

The month i choose in the selection is this:

is my field "MESEFINEVAL"

Re: Table calculation condition

Digvijay_Singh — Tue, 13 Mar 2018 13:56:53 GMT

May be something like this -

Sum({<D_FINE_VAL={"=D_FINE_VAL<=D_FINE_FORN "},MESEFINEVAL={"$(=Max(MESEFINEVAL))"}>}CONSUMO_TOT_ANNUO)

Re: Table calculation condition

danosoft — Tue, 13 Mar 2018 15:42:30 GMT

no in this way it not take out nothing, how can i add in my expression:

Sum({<D_FINE_VAL={"=D_FINE_VAL<=D_FINE_FORN "}>}CONSUMO_TOT_ANNUO)

addthe: D_FINE_VAL = Max(of the Month i choose in selection)

The month i choose in the selection is this:

is my field "MESEFINEVAL"

Re: Table calculation condition

danosoft — Wed, 14 Mar 2018 09:18:59 GMT

Hi i solved it, the solution is this, if it can be helpful for someone:

Sum({<D_FINE_VAL={"=D_FINE_VAL<=D_FINE_FORN"}, MESEFINEVAL = {"$(=MaxString(MESEFINEVAL))"}>}CONSUMO_TOT_ANNUO)