Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to achieve both Dimention Level and Expression Level Grouping in the same report?

Hello...

I need to achieve Dimention Level Grouping as well as Expression Level Grouping in the same report. How can I do this?

My Idea:

1) For this I have created a Dimention Group(3 fields) and Expression Group(3 fields) from Settings --> Document Properties --> Groups (Tab) and used them in the report.

2) I am able to see a small drop-down button for Dimention Level.

3) In order to see the same for Expression Level, I need to add an extra expression(this can either be a group or just an expr) in the expressions. So, there should be atleast 2 expressions for me to view the Expression Level Grouping(file attached), the second one being unnecessary in my report.

I am a newbie to QlikView and doesn't want to use any Variables/Macros. Can I achieve this, if so how?

Please let me know if you have any questions.

Regards,

Madhusudan.

 
0 Replies