topic Straight table alternate state column help needed. in QlikView https://community.qlik.com/t5/QlikView/Straight-table-alternate-state-column-help-needed/m-p/425436#M158464 <HTML><HEAD></HEAD><BODY><P>Hi, I need to make a calculated dimension to follow values in one state and another to follow values in another state to make side-by-side comparison in a straight table but not sure about syntax.</P><P></P><P>I have regular fields like clientname, userid, testname, testvalue and testdate for dimensions.&nbsp; I used a simple count formula as the expression for now.&nbsp; I need to make testvalue and testdate columns to follow Cohort1 alternate state, and another pair of the same columns to follow Cohort2 alternate state in a straight table.&nbsp; I have the listboxes made for each state.</P><P></P><P>(I might be able to wing this in a lumpy expanded pivot table or two straight tables patched together in excel, but would like to try the alternate states set analysis approach here.)</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 30 May 2013 17:37:19 GMT stevelord 2013-05-30T17:37:19Z Straight table alternate state column help needed. https://community.qlik.com/t5/QlikView/Straight-table-alternate-state-column-help-needed/m-p/425436#M158464 <HTML><HEAD></HEAD><BODY><P>Hi, I need to make a calculated dimension to follow values in one state and another to follow values in another state to make side-by-side comparison in a straight table but not sure about syntax.</P><P></P><P>I have regular fields like clientname, userid, testname, testvalue and testdate for dimensions.&nbsp; I used a simple count formula as the expression for now.&nbsp; I need to make testvalue and testdate columns to follow Cohort1 alternate state, and another pair of the same columns to follow Cohort2 alternate state in a straight table.&nbsp; I have the listboxes made for each state.</P><P></P><P>(I might be able to wing this in a lumpy expanded pivot table or two straight tables patched together in excel, but would like to try the alternate states set analysis approach here.)</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 30 May 2013 17:37:19 GMT https://community.qlik.com/t5/QlikView/Straight-table-alternate-state-column-help-needed/m-p/425436#M158464 stevelord 2013-05-30T17:37:19Z