topic Re: Line chart data issue. in QlikView

Line chart data issue.

infosense_devel — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

i have requirement to show country wise data in line chart, but the twist is i have 10 countries data and i have to show it like below.

Desire result:-

VUSA=> America, VCAN=> Canada and VIL=> Total (Total should have all countries data including VUSA and VCAN).

Currently i am getting wrong data because in dimension i have used below expr:

=if(NAME='VCAN_OU' or NAME='VUSA_OU',NAME,'VIL')

So currently i am getting VIL as other than VUSA and VCAN.

in amount i have used below expression:

=sum({<REC_TYPE={BacklogRecHistory},Accounts=,BACKLOG_SBU-={MS},Common_Month=,BACKLOG_WEEK_FLAG={1},[Common_Day (#)]=>}(BACKLOG_AMT + PAST_DUE_AMT))

Please suggest me some other way to achieve my desire result.

Thanks in advance.

Re: Line chart data issue.

sunny_talwar — Thu, 16 Jun 2016 15:47:22 GMT

You can try like this:

=If(NAME='VCAN_OU' or NAME='VUSA_OU',

Sum({<REC_TYPE={BacklogRecHistory}, Accounts=,BACKLOG_SBU-={MS}, Common_Month=, BACKLOG_WEEK_FLAG={1}, [Common_Day (#)]=>} (BACKLOG_AMT + PAST_DUE_AMT)),

Sum(TOTAL <DateField> {<REC_TYPE={BacklogRecHistory}, Accounts=,BACKLOG_SBU-={MS}, Common_Month=, BACKLOG_WEEK_FLAG={1}, [Common_Day (#)]=>} (BACKLOG_AMT + PAST_DUE_AMT)))

Assuming that your first field is DateField. Replace it with whatever you call it in your database

Re: Line chart data issue.

sunny_talwar — Thu, 16 Jun 2016 15:49:21 GMT

Alternatively, just use 1 dimension and three expressions

Sum({<NAME= {'VCAN_OU'}, REC_TYPE={BacklogRecHistory}, Accounts=,BACKLOG_SBU-={MS}, Common_Month=, BACKLOG_WEEK_FLAG={1}, [Common_Day (#)]=>} (BACKLOG_AMT + PAST_DUE_AMT))

Sum({<NAME= {'VUSA_OU'}, REC_TYPE={BacklogRecHistory}, Accounts=,BACKLOG_SBU-={MS}, Common_Month=, BACKLOG_WEEK_FLAG={1}, [Common_Day (#)]=>} (BACKLOG_AMT + PAST_DUE_AMT))

Sum({<REC_TYPE={BacklogRecHistory}, Accounts=,BACKLOG_SBU-={MS}, Common_Month=, BACKLOG_WEEK_FLAG={1}, [Common_Day (#)]=>} (BACKLOG_AMT + PAST_DUE_AMT))

Re: Line chart data issue.

infosense_devel — Thu, 16 Jun 2016 16:02:12 GMT

Really appreciate your reply.

as per your suggestion i have put below expr:

=If(NAME='VCAN_OU' or NAME='VUSA_OU',

Sum({<REC_TYPE={BacklogRecHistory}, Accounts=,BACKLOG_SBU-={MS}, Common_Month=, BACKLOG_WEEK_FLAG={1}, [Common_Day (#)]=>} (BACKLOG_AMT + PAST_DUE_AMT)),

Sum(TOTAL <Common_Date> {<REC_TYPE={BacklogRecHistory}, Accounts=,BACKLOG_SBU-={MS}, Common_Month=, BACKLOG_WEEK_FLAG={1}, [Common_Day (#)]=>} (BACKLOG_AMT + PAST_DUE_AMT)))

but with this expression i am getting TOtal for VUSA and VCAN column also.Please take a look at below screenshot.

Re: Line chart data issue.

sunny_talwar — Thu, 16 Jun 2016 16:04:35 GMT

Can you add another expression and paste its output here:

=If(NAME='VCAN_OU' or NAME='VUSA_OU', 1, 2)

Re: Line chart data issue.

infosense_devel — Thu, 16 Jun 2016 16:35:05 GMT

My Requirement is satisfied by this suggestion thanks a lot.