Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashish_1102
Contributor II
Contributor II

Wildmatch to exclude all dimensions and match with unlinked field

Dear community -

I've a straight table like this -

Pid        Pname                   Min Date                                                       Title                         PubDate

299      G Eq Qu                02-Apr-2018                                                   G Eq Quart             25-Mar-19

                                                                                                                                                02-Apr-2018

                                                                                                                  XYZ                        01-Oct-2018

 

Where Pid and Pname are dimensions and min date is an expression.

I've 2 other fields called title and Pub-date in another table and is not linked to either Pid or Pname.

 

The logic to calculate min date expression is - to wildmatch Pname with title, and if there's a match then pick the minimum  PubDate associated to it.

 

Could anybody please help me in constructing such an expression.

 

many thanks in advance.

 

Labels (3)
1 Solution

Accepted Solutions
andrei_delta
Partner
Partner

hi,

i attached an app as an example.

If you want to do the wildmatch pname should be the mask and title the string you are going to look into.

Hope it helps!

View solution in original post

4 Replies
JordyWegman
Partner
Partner

Hi,

Follow these steps:

  1. Rename Title to Pname. This way they are connected.
  2. Create a table and put Pid and Pname in the table as dimensions
  3. Add Min(PubDate) in as a calculated dimension

Jordy

Climber

Work smarter, not harder
Ashish_1102
Contributor II
Contributor II
Author

Hi Jordy

Thanks for the prompt reply.

 

Sorry I wasn't very clear.

PName and Title can't be linked. infact Pname would be a substring of Title, hence I've to wildmatch and then pick the minimum published date corresponding to Title.

 

Hope that makes sense.

andrei_delta
Partner
Partner

hi,

i attached an app as an example.

If you want to do the wildmatch pname should be the mask and title the string you are going to look into.

Hope it helps!

View solution in original post

Ashish_1102
Contributor II
Contributor II
Author

Thanks a lot. very helpful 😊