topic cross table & different format on Y-axis based on user's choice? in QlikView https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808711#M471698 <HTML><HEAD></HEAD><BODY><P>Hello, I am new to Qlikview, Here are my two questions.</P><P></P><P>1) Currently I could have either of following tables to import.</P><P>I feel table1 is more like cross table, table2 looks better. is my thought correct?</P><P></P><P>2) If I go with table2, when I do something like sum(data), as you see in table 2,</P><P>some cells are number format, some are currency format.</P><P>How could I show correct format on Y-axis (show $ or NOT) when user selects different data type?</P><P></P><P>Many thanks for your tips.</P><P><IMG __jive_id="79519" alt="TABLE.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79519_TABLE.JPG" style="height: 394px; width: 620px;" /></P></BODY></HTML> Sun, 01 Mar 2015 15:00:14 GMT Anonymous 2015-03-01T15:00:14Z cross table & different format on Y-axis based on user's choice? https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808711#M471698 <HTML><HEAD></HEAD><BODY><P>Hello, I am new to Qlikview, Here are my two questions.</P><P></P><P>1) Currently I could have either of following tables to import.</P><P>I feel table1 is more like cross table, table2 looks better. is my thought correct?</P><P></P><P>2) If I go with table2, when I do something like sum(data), as you see in table 2,</P><P>some cells are number format, some are currency format.</P><P>How could I show correct format on Y-axis (show $ or NOT) when user selects different data type?</P><P></P><P>Many thanks for your tips.</P><P><IMG __jive_id="79519" alt="TABLE.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79519_TABLE.JPG" style="height: 394px; width: 620px;" /></P></BODY></HTML> Sun, 01 Mar 2015 15:00:14 GMT https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808711#M471698 Anonymous 2015-03-01T15:00:14Z Re: cross table & different format on Y-axis based on user's choice? https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808712#M471699 <HTML><HEAD></HEAD><BODY><P>Hi surtman</P><P>please attach sample excel file.</P><P></P><P>Regards</P><P>Samwise</P></BODY></HTML> Mon, 02 Mar 2015 05:48:13 GMT https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808712#M471699 mightyqlikers 2015-03-02T05:48:13Z Re: cross table & different format on Y-axis based on user's choice? https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808713#M471700 <HTML><HEAD></HEAD><BODY><P>Sorry for it, Here you are, the two tables. thanks.</P></BODY></HTML> Tue, 03 Mar 2015 02:44:24 GMT https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808713#M471700 Anonymous 2015-03-03T02:44:24Z Re: cross table & different format on Y-axis based on user's choice? https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808714#M471701 <HTML><HEAD></HEAD><BODY><P>Hi Please find the attached qvw and excel file</P></BODY></HTML> Tue, 03 Mar 2015 06:54:38 GMT https://community.qlik.com/t5/QlikView/cross-table-different-format-on-Y-axis-based-on-user-s-choice/m-p/808714#M471701 mightyqlikers 2015-03-03T06:54:38Z