topic Re: Hidden value in a table in QlikView

Hidden value in a table

danosoft — Thu, 21 Sep 2017 08:40:09 GMT

Hi i have a table with some column, i want display the value of coloum SOURCING only when my YEAR is 2017, when year is < 2107 i want display in this column the value 0

Is possible to do that in a table?

thanks

Re: Hidden value in a table

YoussefBelloum — Thu, 21 Sep 2017 08:49:47 GMT

Hi Daniele,

you can do this by using a condition in the dimension, try this:

=if(date < YearEnd(today()), date, 0)

if you have only a field year in your model, you can filter directly on the year:

=if(Year = year(today()), year, 0)

Re: Hidden value in a table

danosoft — Thu, 21 Sep 2017 08:58:11 GMT

Hi, sorry but is not a GRAPH object is a Table object, i not have dimension

Re: Hidden value in a table

YoussefBelloum — Thu, 21 Sep 2017 09:13:37 GMT

A table box does not support calculations.

What can you do is select that field based on a button or trigger or try to make specific calculations on the script.

Re: Hidden value in a table

danosoft — Thu, 21 Sep 2017 09:23:50 GMT

Sorry i understand that i can't do that, but i not understand what you mean for "based on a button or trigger" or making specific calculation on a script... how can i do that?

Re: Hidden value in a table

YoussefBelloum — Thu, 21 Sep 2017 09:57:10 GMT

You can use a button to make a selection of the year you want, so the table will update on that selection.

you can also create a trigger that can be launched on multiple things, like when you open the app, when you open a sheet, etc...

about the calculation on the script: you can use a second load with a "where" condition for the year you want and concatenate this load on the first table.

tell me if it is clear.

Regards,

Youssef

Re: Hidden value in a table

pradosh_thakur — Thu, 21 Sep 2017 10:03:26 GMT

This is easy to do with a straight table but with table box it is hard may be not possible.

but one workaround you can do is by adding an extra column in the model sourcing_copy

sourcing_copy expression ->if(sourcing=2017,sourcing,0) as sourcing_copy

in place of 2017 you can get the current year using function.

hope this helps.

Regards

Pradosh

Re: Hidden value in a table

danosoft — Thu, 21 Sep 2017 10:09:36 GMT

you mean i can put in my model like this?:

LOAD

ANNO,

"SOURCING",

if(sourcing>2017,sourcing,0) as sourcing_copy

SQL SELECT *

FROM "XXX"."V_XXX_16_17";

Re: Hidden value in a table

pradosh_thakur — Thu, 21 Sep 2017 10:43:17 GMT

LOAD

ANNO,

SOURCING,

if(SOURCING=2017,SOURCING,0) as SOURCING_COPY

SQL SELECT *

FROM "XXX"."V_XXX_16_17";

As per your condition sourcing should be 2017 or else zero.. so check that then do it. make sure you write field name properly