Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner - Creator II
Partner - Creator 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
alexandros17
Partner - Champion III
Partner - Champion III

The dimension must be:

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

and check the box "Suppress when value is null"

Hope it helps

View solution in original post

3 Replies
Not applicable

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

alexandros17
Partner - Champion III
Partner - Champion III

The dimension must be:

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

and check the box "Suppress when value is null"

Hope it helps

er_mohit
Master II
Master II

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