topic Re: Grouping help in QlikView

Grouping help

dhanu_today — Thu, 13 Feb 2014 07:26:22 GMT

Hi All,

I have the req below.

I have to show the the bifurgation of total amount into increase and decrease columns with respect to their id's.

But in the design level i have to show only the increase and decrease rate and no need to show the Ids.

The fields are coming from different tables.Help in design level is added adv.

Please find the attached doc for clarification.

Thanks

Dhanu

Message was edited by: dhanu today

giakoum — Thu, 13 Feb 2014 07:40:01 GMT

see attached

dhanu_today — Thu, 13 Feb 2014 08:39:06 GMT

Thanks Loannis...Its my bad..I dont have increase and decrease fields as input.

Rgds,

Dhanu

dhanu_today — Thu, 13 Feb 2014 15:38:49 GMT

Any one is there !!!

Thanks,

Dhanu

Thu, 13 Feb 2014 15:51:36 GMT

Dhanu,

1) Either in SCRIPT (if you want 3 fields)

LOAD Amount,

if(Amount > 0, Amount) as Increase,

if(Amount < 0, Amount) as Decrease

FROM xxxx

2) Or In the UI

expression Increase for ex: sum(if(Amount>0, Amount))

Fabrice

nirav_bhimani — Thu, 13 Feb 2014 16:33:52 GMT

Try to create a Flag in the script,

If (Amount>0, 'Inc', 'Dec') as Flag

Then used this condition in the Set Analysis like

Sum({<Flag={'Inc'}>}Amount) //for Increase

Sum({<Flag={'Dec'}>}Amount) //for Decrease

Hope this might resolved your problem

Regards,

Nirav Bhimani