Repeat values on Straight table

[#1]

Greetings

Please assist to calculate grp2, grp3 and grp4 columns on Qliview model.

Many Thanks.

[PrashantSangle]

Hi,

Be more specific. Not able to understand your requirement.

might below syntax help you

Sum(Total <grp1>Values)

Regards

[Anonymous]

=count({< grp2={'Total X','Total Y','Total Z','Total XY','Total XYZ'}>}Didstinct Line2)

[#4]

Thanks for responding.

Sum() is not working as it is a string value.

Is it possible to do it on script level.

Thanks

[Peter_Cammaert]

It seems like you already have a pivot/straight table with dimensions and a grp1 calculation expression (the columns in white). Can you upload that QVW?

[Anonymous]

load

count(distinct field name) as count1

resident tablename

or we take the textbox write the expression

=count({< grp2={'Total X','Total Y','Total Z','Total XY','Total XYZ'}>}Didstinct Line2)

[Peter_Cammaert]

You can also search the Community for Profit&Loss solutions. They typically operate in the same way.

Or look here for an excellent treatment: How IntervalMatch Solved My Profit and Loss Dilemma

Best,

Peter

[#8]

Hi Peter

Please find attach the QVW file.

Please let me know if can do it by script level/DB level.

Regards

Sandeepa

[Anonymous]

take a straight table and write the is count(gr2) and take the columns are gr1 and gr2 it is working

[#10]

sandeepa

I do not see an attached qvw?