topic Re: How do I calculate the expression dynamically or through program? in QlikView

How do I calculate the expression dynamically or through program?

Mon, 13 May 2013 06:53:23 GMT

Hello Experts,

Need your help with the following. Attached file contains sample data . This contains credit card usage data for one particular credit card on monthly basis.

When User selects a Particular Month, I want to display a graph of 10% incremental value(difference between max and min amount charged) charged_amount, number of users who spent the amount and total sum of those users

My data as per excel as per below image.

For example, If Month is 201301,

Lowest Amount is 350

Highest Amount is 9000

So the expression starts from 0 <350 then increment by 10% of difference between maximum amount and minimum amount charged((9000-350)/10)

We want to know every 10% increment number of users and total amount spent during the month by these group of users.

Manually calculated results as follows.

How do I implement this?

Thank you.

Re: How do I calculate the expression dynamically or through program?

kumarnatarajan — Mon, 13 May 2013 08:42:55 GMT

Hi,

Find the attached file it is very helpfull for you

Re: How do I calculate the expression dynamically or through program?

Mon, 13 May 2013 21:47:10 GMT

Hi Kumar

Thank you for the help. In your suggestion you have hard coded the values for Dimension. In typical scenario this values and range is dynamic. Jan range is 350-9000 but in Some other month it may be 100-15000. So we should calculate this value dynamically

In addition there is an error

Thank you and looking forward for your help