Date Dimension in to 1 line

[Anonymous]

Hi,

Its might be a very basic thing to do but for some reason, I am not able to do it.

I have date Dimension, which is showing in multiple lines, i want to bring total of expression by date in 1 line, as you can see here.

I will really appreciate if someone can help on this.

Regards,

M Talal

[sunny_talwar]

Seems like your date is formated as date, but in fact it is a timestamp.... You can fix this in the script or using a calculated dimension

Date(Floor(PVX_DATE)) as PVX_DATE

[stigchel]

Load your PVX_DATE the following way (or in a new field)

Load

     Date(Floor(PVX_DATE),'DD/MM/YYYY')

From....

This removes any time related info from PVX_Date

[Anonymous]

Hi Sunny,

If i use it on the script, my other tables will be disturbed where i need all the lines,

any chance i can do this without script.

[sunny_talwar]

Try it as a calculated dimension

Calculated Dimensions

Date(Floor(PVX_DATE))

[vinieme12]

I think you are using a Tablebox

You should be using a Straight table and PVX_DATE as Dimension and Sum(Container) as Expression

[sunny_talwar]

vinieme12‌ I see totals here, how can this be a table box?

[vinieme12]

OH didn't see that

[Anonymous]

I tried this but now

no result as you can see in the pic sunny

[sunny_talwar]

Seems like your PVX_DATE is not read as date.... either share a sample to see the issue or go through these the way to fix the PVX_DATE using Date#() or TimeStamp#()

Why don’t my dates work?

QlikView Date fields

Get the Dates Right