topic Re: Table based on certain parameters in QlikView

Table based on certain parameters

Thu, 11 Oct 2012 12:02:44 GMT

Hi Guys,

i have a straight table that i only want to be displayed when a certain set of parameters are met like over a certain weight or a certain amount of orders per site

have been reached.

what would be the best way of doing this?

thanks for your help

Re: Table based on certain parameters

Thu, 11 Oct 2012 13:31:22 GMT

Go to Layout in Properties and put your condition under show/Conditional.

Regards

Mhatim

Re: Table based on certain parameters

Thu, 11 Oct 2012 15:11:02 GMT

Hi Mhatim,

i tried this i put in there Units >= 3 so it should display all units over or equal to 3 but it doesnt do anything

Re: Table based on certain parameters

Thu, 11 Oct 2012 15:17:28 GMT

Put in the entire expression if(Units>=3,True(),False())

Hope this helps

Regards

Mhatim

Re: Table based on certain parameters

Thu, 11 Oct 2012 15:35:24 GMT

Hi,

i created a chart and set this in the Dimensions tab

=if(Units>=3,job) this then shows me all jobs with a unit over equal or greater than 3 i then want to see on the same chart anything also greater than or equal to a weight of 3000 would i put this under expressions ? with a similar syntax?

Re: Table based on certain parameters

Fri, 12 Oct 2012 09:35:28 GMT

Yes,you rae right.

Was your earlier query resolved ?

Regards

Mhatim