Discussion Board for collaboration on QlikView Layout & Visualizations.
Go to Solution.
Do you have any condition to filter the data in table.
I dont have any conditions.
Are you want to dispaly maximum date for object type or what ?. I am confused with the final output table you provided .
I want to count only the first value in the table.
For example Object_Type = 'AAA' , Object_ID=1 it appeared 2 times in the table (01/01/13, 05/01/13)
I want to count him only in the date 01/01/13 and discard him in 05/01/13.
To count up the number of entries appearing on the first date that a Object_Type occured, something like this might work as an expression, with Object_Type as the dimension:
or using set analsysis:
For the date column, you could then use:
Thanks for your answer but it dosn't work.
Seems you need to calculate the minimum date across each type. Try:
Still not good.
in your QVW the table contain 1 date (01/01/2013) with 2 types (AAA,BBB) but should have 2 dates (01/01/13,02/01/13) - see the table above.
Like Sunil, I'm confused about the decision of what dates to output.
How do you decide to output AAA on 02/01/13 ?