topic Re: Modify Dimension in QlikView

Modify Dimension

robert_mika — Sat, 31 Jan 2015 23:13:24 GMT

This is maybe obvious but is is possible instead of creating Calculated Dimension change an existing one "on fly"

To Example:

If I had Dimension "Dates"

1/1/2012

2/2/2013

Create :

Year(Dates)

So my Expression will read:

IF(Year(Dates)='2013'

or COUNT(${<Year(Dates)={'2013'}....

Re: Modify Dimension

sujeetsingh — Sat, 31 Jan 2015 23:29:00 GMT

You can use the calculated dimension.

Well i do not think you can create any value in UI.

You can achieve this in script.

you can have master calender concept.

Follow this

Creating A Master Calendar

Re: Modify Dimension

Sat, 31 Jan 2015 23:40:54 GMT

You can't modify a field on the fly. That needs to be done on the script, which is the recommended way.

Just create it on the script like: "Year(Dates) as Year" and then you can use COUNT(${<Year={'2013'} Field).

If by any reason you can only do it on the front end, then you can create a variable, let's say vYear, define it to be "=Year(Dates)" and then you can use COUNT(${<$(vYear)={'2013'} Field).

Or, without creating anything, you can still use COUNT(${<$(=Year(Dates))={'2013'} Field), on the fly.

But like I said, it's better to have all necessary fields created in the script.

Hope this helps.

Kind regards,

Nuno