topic Straight Table problem remaining value problem in QlikView

Straight Table problem remaining value problem

Thu, 08 Mar 2012 09:45:42 GMT

Hi friends

i have Straight Table which will have indicator .that is if the required quantity is greater than the available quantity(indicator in red).We are trying to show next 5 days.My Problem is if the Required Qty is less than Available qty(Indicator in green),RequiredQty-Available Qty=remaining value.That remaining value has to be added to the next Day?

How can i Achieve it?

Please help me out

Thanks in advance

Straight Table problem remaining value problem

Thu, 08 Mar 2012 10:01:58 GMT

Hi friends

here i have Attached the image

Re: Straight Table problem remaining value problem

Anonymous — Thu, 08 Mar 2012 10:44:25 GMT

Hi suresh ,

using the pivot/stright table you can do it.

I dont know you can use the indicator in thest table instead of this you can change the table row/col cell color red or

green based on your condition.

like quantity is greater than the available quantity then that cell will display in red background color.

to achieve this you can give the condition in the expression tab of chart properties.

see the image

Re: Straight Table problem remaining value problem

Anonymous — Thu, 08 Mar 2012 10:45:31 GMT

Image file