Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Repeat values on Straight table

Greetings

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

Capture.PNG

Many Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

14 Replies
PrashantSangle

Hi,

Be more specific. Not able to understand your requirement.

might below syntax help you

Sum(Total <grp1>Values)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

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

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

Hi Peter

Please find attach the QVW file.

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

Regards

Sandeepa

Anonymous
Not applicable
Author

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

Not applicable
Author

sandeepa

I do not see an attached qvw?