topic Re: Calculated dimension in QlikView

Calculated dimension

pauldamen — Wed, 03 Jul 2013 08:49:52 GMT

All,

I have a straight table with 5 dimensions and 3 expressions. The data is taken from QVD's which are stored every week with new data and the document reads in the last 8 weeks off QVD's.

Now the table I am making should only show data from the most recent QVD (QVD's are stored with week numbers so the name is WeekXData).

I thought to add a calculated dimension: Week = vWeek. This does return the correct items but it adds a column with 0 and -1 for data that matches with this item and that doesn't.

How can I get the table to only show the values from the latest week?

Regards,

Paul

Re: Calculated dimension

Wed, 03 Jul 2013 08:57:40 GMT

I don't think for this result you need to write calculated dimension..

You can simply right this on set analysis in expression..

If you need in on Calculated dimension,

You can right like.. If(Week=vWeek,Week,'') and set "Suppress Null Value"

Regards,

Karthik

Re: Calculated dimension

alexandros17 — Wed, 03 Jul 2013 08:58:56 GMT

The dimension must be:

if(Week=vWeek, Week, null())

and check the box "Suppress when value is null"

Hope it helps

Re: Calculated dimension

er_mohit — Wed, 03 Jul 2013 09:05:55 GMT

i think there's some mistake the value it gives 0 and -1 for false and true values but don't know how it gives the way of you is something like wrong so, try this in calculated dimension

if(Week=vWeek,Week) and check on sppress null value

hope it helps