Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

chart control sum

Im using qlikview 8.5

The below is query is used for chart control and works fine

SQL SELECT

Day(PostingDate) as InvoiceDay,

Month(PostingDate) as InvoiceMonth,

Year(PostingDate) as InvoiceYear,[EntryType]

      ,[BillNo]

      ,[Description]

      ,[amt],Account

FROM IETracking;

and I have other chart control I need to show only the sum(amt)

where Account=expenses.

How can i do that in chart control

1 Solution

Accepted Solutions
its_anandrjs

In chart try some think this way

if(Account='expenses',sum(amt))

Regards

Anand

View solution in original post

5 Replies
its_anandrjs

Hi,

In the load script write like

SQL SELECT

      [BillNo]

      ,[Description]

      ,Account

      ,Sum([amt]) as AmtSum

FROM IETracking Where Account='expenses'

Group By [BillNo],[Description],Account;

Regards

Anand

Not applicable
Author

im aware of your query, I have lot of Accounts information, which cant be accommodated in where clause

I want use in the control

its_anandrjs

I did not understand what do you mean by control or you are asking about the Qlikview front end.

Regards

Anand

Not applicable
Author

in chart properties in the expression tab, see if i can

if Account='expenses' sum(amt)

im not exactly sure, where to add this logic

its_anandrjs

In chart try some think this way

if(Account='expenses',sum(amt))

Regards

Anand