topic Re: Fixed date in table in QlikView

Fixed date in table

Wed, 23 Jul 2014 09:24:58 GMT

Could any one help with displaying date in a table for a fixed day.

Scenario, Table column = Day

which is 1st, 2nd 3rd etc.

I want my table to only ever display day 1st REGARDLESS of any other selections.

Is this possible.

Help appreciated.

Emma

Re: Fixed date in table

alexandros17 — Wed, 23 Jul 2014 09:31:26 GMT

If Day is a dimension then write:

if(Day=1,Day, Null()) and check the box "suppress null values"

Re: Fixed date in table

Wed, 23 Jul 2014 09:37:45 GMT

Thank you for the response but there is no dimension in table object?

Re: Fixed date in table

Wed, 23 Jul 2014 09:39:57 GMT

When you say 1st day, do you mean the minimum day loaded?

=DATE(min({1}Day)) // with {1} you exclude all the selections

hope that helps,

David

Re: Fixed date in table

Wed, 23 Jul 2014 09:44:04 GMT

try to use a combination of

lets say Date field is A

Min({1}A)

this will bring all data regardless of selection

and use dimension limits

this will help you

i will try to attaché file for this example

Re: Re: Fixed date in table

Wed, 23 Jul 2014 09:45:46 GMT

please check this example

Re: Fixed date in table

Wed, 23 Jul 2014 09:46:02 GMT

Hi David

Thanks for your reply and this is useful to know, however what if it was not the min I wanted to fix, but say all the 3rds data ?

Thanks again

Emma

Re: Fixed date in table

Wed, 23 Jul 2014 10:11:19 GMT

Sorry,

I don't understand the issue... can you attach an example?

Re: Fixed date in table

Wed, 23 Jul 2014 10:11:59 GMT

Hi Omar

Thanks for the reply but what if I didn't want min and wanted to say fix to 3rd ?

Re: Fixed date in table

jvishnuram — Wed, 23 Jul 2014 10:17:38 GMT

Hi Emma,

Then you can use Min({1} Date,3)

Re: Fixed date in table

Wed, 23 Jul 2014 10:38:10 GMT

Hi Vishnu

I entered this into my calculated condition for the table but it is still showing ALL dates ?

Re: Fixed date in table

Wed, 23 Jul 2014 10:55:22 GMT

Please fix day in table on attached to 22

Re: Fixed date in table

jvishnuram — Wed, 23 Jul 2014 11:02:07 GMT

Hi Emma,

Could you post a sample application.

Re: Fixed date in table

Wed, 23 Jul 2014 11:10:36 GMT

Instead of a simple table build a straight table adding all the dimensions and an expression like this:

max({<Day={22}>}QueryID)