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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
ivanyang25
Contributor III
Contributor III

How to put different dimension into one column at the same time

Dear QS Experts

I am new to Qlik Sense and I am a front end user which means I don't need to import data by script from back end side

Now my raw data is as below

1.PNG

The result I need is as below. The indications are the dimensions I need and I need to put them all in the same pivot table at the same time so that I can show a specific table for my client as he requests

2.PNG

The requests are as below.

1. Use expression in master item (dimension)

2. All the indicators above should exit at the same time which means

    a. I can't use bookmark for each indicator to show the data I need one by one (in each bookmark)

    b. I can't use below selection to achieve each indicator by selecting them (as we can only have one result each time)

3.PNG

So may I know if its possible to put different fixed dimension (with expression) under one column at the same time in Qlik Sense?

If so, how can we do so?

Thank you for you advise in advance

Ivan

Best Regards

10 Replies
ahaahaaha
Partner - Master
Partner - Master

Was glad to help.