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: 
Riya07
Contributor II
Contributor II

Creating one dimensions from two different dimensions having values

Hi,

I have two dimensions

Dim 1
YTD

Dim 2
31-Mar-2021
30-Jun-2021
30-Sep-2021
31-Dec-2021

I want to combine both the dimensions into one single dimension to show it in my filter condition in my app

Dim 3
31-Mar-2021
30-Jun-2021
30-Sep-2021
31-Dec-2021
YTD
Was hoping if anyone can help me with this?

Labels (4)
3 Replies
Digvijay_Singh

Not sure what exactly you need, what if you concat Dim1 and Dim2 tables in the script? 

 

Riya07
Contributor II
Contributor II
Author

Hi Digvijay,

I wanted the dimension Dim3 to have values from both Dim1 and Dim2. In the filter drop down menu we would have another value of YTD apart from the quarter dates. 

Digvijay_Singh

Did u try concatenating YTD in the script like below, but I am not sure how you are going to use this filter pane, you might need to check in you chart expression the selected value in this filter pane to understand what it needs to show -


Dim1:
Load * inline [
Dim
YTD
];

Concatenate(Dim1)
Load * inline [
Dim
31-Mar-2021
30-Jun-2021
30-Sep-2021
31-Dec-2021
];

Digvijay_Singh_0-1646091656832.png