Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-10-02 05:18 PM

Apply filter to specific dimension within Dimension Group

Hello,

I have defined Dimension Group as below:

IF(Field1=1 ,IF(Field2=1,'A'),

IF(Field1=2,IF(Field3=1,'B'),

IF(Field1=3,IF(Field4=2,'C')));

Field2 has other values.

Now, I would like to ignore Field2 filter on row 'B' (Only). Is that possible?

Thanks,

Greeshma

573 Views
3 Replies
MK_QSL
MVP
MVP
‎2015-10-03 04:00 AM

Your question is difficult to understand. Can you please provide some more information (possibly with sample data)?

251 Views
0 Likes
Anonymous
Not applicable
‎2015-10-03 05:03 AM
Author

Hi,

please elaborate on your question.

251 Views
0 Likes
Not applicable
‎2015-10-06 01:37 PM
Author

In response to Anonymous

I am using a table to display different dimensions. However, Table only allows single dimension. Hence, I have added all the necessary dimensions through if..else.

Below is the expression for the table dimension where there are 3 dimensions A, B and C. Each of them are calculated based on different conditional data.

IF(Field1=1 ,IF(Field2=1,'D1'),

IF(Field1=2,IF(Field3=1,'D2'),

IF(Field1=3,IF(Field4=2,'D3')));

Now, I would like D1  to ignore any filters on Field3. However this should not impact D1 or D3. My question really is how to limit the scope of data within if conditions?

Hope this helps.

251 Views