topic Check latest create date? in QlikView

Check latest create date?

Wed, 29 Sep 2010 16:56:44 GMT

Hi All,

Basic query. How can I check for the latest record created date using Set Analysis(I want to create a filter to display the data for the latest created date where I have records from year 2006). My date format is in "mm/dd/yyyy 00:00:00".

Thanks in Advance,

Mady

Check latest create date?

vgutkovsky — Wed, 29 Sep 2010 17:24:30 GMT

Mady,

Well, it's tricky in set analysis because set analysis is evaluated globally. Meaning, it's hard to make it return the latest created date while respecting your dimensions. Rather, it will return the latest created date overall. The general syntax you can use is max(createddate). If it doesn't work in set analysis you could do it with IFs and AGGRs.

Regards,

Check latest create date?

Thu, 30 Sep 2010 16:18:43 GMT

Hello Vlad,

Thank you for the response, it was useful.

Another simple query(I think).. How can i hide a column Label within the Pivot Chart..(I have an expression which i dont want to display in the columns of Pivot Chart).. Is this possible in QV9, SR5, 64Bit.

Thanks in Advance,

Mady

Check latest create date?

Thu, 30 Sep 2010 16:25:49 GMT

You could hide the column label with the expression =' ' in other words quoting a space. This is better than using =null() because this will show as '-' (the default for showing null)

Regards,

Gordon

Check latest create date?

Fri, 01 Oct 2010 10:07:08 GMT

Hello Gordon,

Thank you for the reply, but it helped me only half way I through I think. I want to hide the whole Dimension column including the label, however when I try to do as mentioned by you, its hiding only the column label. Any suggestions...?

Thanks Again,

Madhu A

Check latest create date?

Fri, 01 Oct 2010 10:22:40 GMT

Ah - terminology - you referred to 'expression' which I took to mean 'expression' rather than 'dimension'.

I think the only way to do this is to make the dimension column 0 width in the chart. Create a macro and use this code:

set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties

set dims = p.Dimensions
dims(1).ColWidth = 0
chart.SetProperties p

attach it to a button and click it - you only need do this once. Note that dims are numbered from 0 so the example relates to the 2nd dimension in the chart.

Regards,

Gordon

Check latest create date?

Fri, 01 Oct 2010 10:30:28 GMT

HI Madhu,

I don't think its possible to hide the expression column but you can make a work around on this.

First set the label of your expression into ='' then under Display Option>Reperesentation> Choose Image

Next Check the checkbox "Hide Text when Image Missing"

Then set your expression column width to minimum (by dragging column border).

This just actually hides (from view). If someone knows how to hide expression columns in Pivot Table let us know.

Thanks,

Nadsky

Check latest create date?

Fri, 01 Oct 2010 10:35:31 GMT

Hi Gordon,

Thanks for the info!... Too bad we can't use macro in our dashboards. Coz were using ZFC (Zero footprint client).

Is there any way we can hide expressions in pivot table? (aside from macro and my solution)

Thanks!