topic Re: Repeat values on Straight table in QlikView

Repeat values on Straight table

Thu, 14 Jan 2016 12:01:48 GMT

Greetings

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

Many Thanks.

Re: Repeat values on Straight table

PrashantSangle — Thu, 14 Jan 2016 12:08:55 GMT

Hi,

Be more specific. Not able to understand your requirement.

might below syntax help you

Sum(Total <grp1>Values)

Regards

Re: Repeat values on Straight table

Anonymous — Thu, 14 Jan 2016 12:12:06 GMT

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

Re: Repeat values on Straight table

Thu, 14 Jan 2016 12:16:25 GMT

Thanks for responding.

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

Is it possible to do it on script level.

Thanks

Re: Repeat values on Straight table

Peter_Cammaert — Thu, 14 Jan 2016 12:20:07 GMT

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?

Re: Repeat values on Straight table

Anonymous — Thu, 14 Jan 2016 12:21:29 GMT

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)

Re: Repeat values on Straight table

Peter_Cammaert — Thu, 14 Jan 2016 12:24:46 GMT

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

Re: Repeat values on Straight table

Thu, 14 Jan 2016 12:26:05 GMT

Hi Peter

Please find attach the QVW file.

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

Regards

Sandeepa

Re: Repeat values on Straight table

Anonymous — Thu, 14 Jan 2016 12:29:12 GMT

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

Re: Repeat values on Straight table

Thu, 14 Jan 2016 13:01:31 GMT

sandeepa

I do not see an attached qvw?

Re: Repeat values on Straight table

Thu, 14 Jan 2016 13:43:08 GMT

PFA.

Regards

Re: Repeat values on Straight table

rodri_morales — Thu, 14 Jan 2016 13:51:13 GMT

You could do it in script.

When you load the data you could make a left join and add a calculate column making sum().

But we need you explain a little more about the model. What is the calculation for gpr2, gpr3 and gpr4 for example.

Re: Repeat values on Straight table

rodri_morales — Fri, 15 Jan 2016 13:01:05 GMT

sandeepa, could you please explain a little more?

I see the attached file, wich no script code is there. Explain how is the calculation, do you want to do a cumulative sum?

I think is like finance and economics tables, but you never told something.

Re: Repeat values on Straight table

Fri, 15 Jan 2016 13:16:55 GMT

Thank You all for responding.

Please find attach the QV model and source file.

I could not able to calculate it on Model level so did it on DB level using cursor.

Regards

Re: Repeat values on Straight table

Anonymous — Mon, 18 Jan 2016 10:14:32 GMT

count(column name{<values>}distinct column name)