Discussion board where members can get started with QlikView.
Good day, can you help me?.
I have the following table:
I must subtract the date greater with the minor by user_id, but respecting the order.
I need the following:
Go to Solution.
Just extend the if() clause:
LOAD recno() as RecID,
if(peek(user_id)=user_id and peek(bug_id)=bug_id,peek( user_group_id), peek(user_group_id)+1)) as user_group_id
(html, codepage is 1252, embedded labels, table is @3);
You need to uncheck Suppress Zero Values in presentation tab to see all user_group_id values, also the ones with zero difference in date_modified.
Maybe like attached?
I am not sure what you are doing with bug_id, but since you said "by user_id", it seems to me that you don't need to group by or check bug_id.
I used this load statement:
if(RecNo()=1,1,if(peek(user_id)=user_id,peek( user_group_id), peek(user_group_id)+1)) as user_group_id
(html, codepage is 1252, embedded labels, table is @1);
creating a user_group_id with e.g. two distinct ids for user_id 2.
Then I created a chart with dimensions user_group_id, user_id, bug_id (and I've hided the user_group_id in presentation tab), and as expression:
Hope this helps,
bug_id is also a field to grouping.
How he added this field in the band?.
Thank you very much!!
Is fantastic, i needed.
Than you very much.