Issue with Hideprefix and Current selections box

Wed, 01 Feb 2012 06:09:52 GMT

Hi All,

I have a requirement where I need to show the [As of Date ] of the data source file.. Here is some sample data ..

Title As of date

Vendor 31/12/2011

Location 10/01/2012

Project 31/01/2012

I need to show the As of date of the Project in one of the sheet..

In order to do that I have written a simple if condition (if(Title='Project',[As of Date]). This works fine but the problem is all the time a selection is need to be made in the Title field so that the same will reflect in the Current selections box.I thought of hiding the field using the Hideprefix but I dnt know it is not working..

Any solution other than this are appreciated..

Attaching the sample document for your reference..

Thanks in advance..

Issue with Hideprefix and Current selections box

kaushiknsolanki — Wed, 01 Feb 2012 06:18:30 GMT

HI,

Try this expression

=only({<Title= {"Project"}>}[As of date])

Regards,

Kaushik Solanki

Issue with Hideprefix and Current selections box

Wed, 01 Feb 2012 06:32:38 GMT

Hi Kaushik,

Thank you for Quick reply.. I forgot of doing the same in Set analysis..

Regards,

Lavanya

topic Issue with Hideprefix and Current selections box in QlikView

Issue with Hideprefix and Current selections box

Issue with Hideprefix and Current selections box

Issue with Hideprefix and Current selections box