Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pauldamen
Contributor II

Calculated dimension

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

1 Solution

Accepted Solutions

Re: Calculated dimension

The dimension must be:

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

and check the box "Suppress when value is null"

Hope it helps

3 Replies
Not applicable

Re: Calculated dimension

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

The dimension must be:

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

and check the box "Suppress when value is null"

Hope it helps

er_mohit
Honored Contributor II

Re: Calculated dimension

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

Community Browser