Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Animated chart

Hi everyone, I'm new in this, well this is my query: I have a bar char with calculated expression "=count(if(BillOperation=0, Bill_Number))" and other types changeing the values of BillOperation (the bill has 3 states: Precharge, Process, Paid). I want to know how to do to animate the chart, so when I click in a bar (that count the bills that are in precharge state for example) I want that the other charts o pivot table show me the "precharge bills" or the bills that have BillOperation=0.

1 Solution

Accepted Solutions
Creator II
Creator II

I create in the scryp a new dimension:

if(BillOperacion=0, 'PreCharge', if(BillOperation>0 and PaidOperation=0, 'Process', if(PaidOperation>0, 'Paid'))) as DimBill

And I use it in the chart.

View solution in original post

1 Reply
Creator II
Creator II

I create in the scryp a new dimension:

if(BillOperacion=0, 'PreCharge', if(BillOperation>0 and PaidOperation=0, 'Process', if(PaidOperation>0, 'Paid'))) as DimBill

And I use it in the chart.

View solution in original post