# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Creator III

## Dimension logic

Hi,

Delow is the dimension logic used in the straight table.But here i need to sort the month also as hardcode to Aug in the same expression.

Kindly let me know if it is possible.

Logic : =if([Sold Location] = '000', 'Goal', if([Sold Location] = '999', 'Company', if([Sold Location] = '888', 'District', if(match([Sold Location],'17','18','29','70','76','102','105','129'),[Sold Location]))))

In the above logic i need to include month as well.

Thanks..

11 Replies
MVP

Where are you using month in this calculated dimension? I am not seeing that above?

Creator III
Author

Hi Sunny,

The requirement is to include the month filter in the above calculated dimension .

Thanks..

Champion III

I am not sure if this works, may be Sunny can come up with better way, mean while you can try this?

= IF( Month= 'Aug', Pick(Match([Sold Location], '000', '999', '888'), 'Goal', 'Company', 'District'),

IF(Month = 'Aug' AND match([Sold Location],'17','18','29','70','76','102','105','129'), [Sold Location]))

Creator III
Author

Hi,

It means my calculated dimension needs to include month as well.

Thanks..

Hard code means this? Or else would you describe what is your intend to use this

=if([Sold Location] = '000', 'Goal', if([Sold Location] = '999', 'Company', if([Sold Location] = '888', 'District', if(match([Sold Location] ,'17','18','29','70','76','102','105','129'),[Sold Location], if(month(field) = 'Aug', 'Aug')))))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator III
Author

Yes..i need to hard code like this..but the logic is not working.

It's not filter the data for the month Aug and also it inserts an new column Aug in the table.

Thanks..

MVP

May be this:

=If(Month = 'Aug',

If([Sold Location] = '000', 'Goal',

If([Sold Location] = '999', 'Company',

If([Sold Location] = '888', 'District',

If(Match([Sold Location],'17','18','29','70','76','102','105','129'), [Sold Location])))))

or

=If(Num(Month) = 8,

If([Sold Location] = '000', 'Goal',

If([Sold Location] = '999', 'Company',

If([Sold Location] = '888', 'District',

If(Match([Sold Location],'17','18','29','70','76','102','105','129'), [Sold Location])))))

Contributor III

Hi

Regards,

Gireesh.

Creator III
Author

Hi Sunny,

The locations were came out as null.

Thanks..

Community Browser