Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
The dimension must be:
if(Week=vWeek, Week, null())
and check the box "Suppress when value is null"
Hope it helps
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"
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