topic Re: Need Help ! in QlikView

Need Help !

dhanu_today — Thu, 13 Mar 2014 17:24:16 GMT

Hello All,

I have calculate the data as per the attached source.

The desired output shouls be as below.

Company_segment Count(company_codes) Count(accounts_no) sum(balance)

Please find the attached source data and the application as well. let me know any concerns..

Thanks in advance,

Dhanu

Re: Need Help !

giakoum — Thu, 13 Mar 2014 17:28:27 GMT

add the distinct in your expressions :

Count(distinct company_codes)

Re: Need Help !

dhanu_today — Thu, 13 Mar 2014 17:31:50 GMT

Thanks..I am stuck at next level.

Re: Need Help !

jsingh71 — Thu, 13 Mar 2014 17:41:14 GMT

Should you want below output? Balance field is not there in your loaded data.

Re: Need Help !

dhanu_today — Thu, 13 Mar 2014 17:54:16 GMT

Yes ..its not there..But from the attached source data from the sheet balance..i have to do the data model to the application and then i have to get the table1 and table 2 as output.

Thanks,

dhanu

Re: Need Help !

giakoum — Thu, 13 Mar 2014 17:55:35 GMT

do you know how or do you need help?

Re: Need Help !

dhanu_today — Thu, 13 Mar 2014 17:56:19 GMT

I need help 🙂

Re: Need Help !

giakoum — Thu, 13 Mar 2014 18:03:48 GMT

You need to fix the period format in your excel file. it has to be consistent.

02/09/2014

25/02/14

Re: Need Help !

dhanu_today — Thu, 13 Mar 2014 18:06:06 GMT

I will correct that.Its my type mistake.

Re: Need Help !

giakoum — Thu, 13 Mar 2014 18:07:23 GMT

then it will be easy

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Individul:

LOAD Account_no,

Company_code,

Cust_id,

BS_Segment,

PS_segment,

period

FROM

source.xlsx

(ooxml, embedded labels, table is Individul);

company:

LOAD Company_code,

Company_Cust_id,

Comp_segment

FROM

source.xlsx

(ooxml, embedded labels, table is company);

balance:

LOAD Balance,

period

FROM

source.xlsx

(ooxml, embedded labels, table is Amount);

Re: Need Help !

dhanu_today — Thu, 13 Mar 2014 18:20:26 GMT

Thanks Loannis..But with this data model...i didn't get the table 1 output say the fields comp_bs_segment and comp_ps-segment.

Re: Need Help !

giakoum — Thu, 13 Mar 2014 18:22:09 GMT

.....

BS_Segment as comp_bs_segment,

PS_segment as comp_ps-segment,

.......

Re: Need Help !

dhanu_today — Thu, 13 Mar 2014 18:26:17 GMT

Could you please share the app what the way you did...I need to show individual level BS_segement, ps_segemnt, and comp_ps_segemnt , comp_bs_segment in company level.

Thanks

dhanu

Re: Re: Need Help !

giakoum — Fri, 14 Mar 2014 08:15:13 GMT

How do you calculate the last 2 columns? Comp_BS_segment and Comp_PS_segment?

Otherwise see attached