Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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: 
UserID2626
Creator II
Creator II

need only one month as dimension qlik sense

hi,

     i have 2 months of data july 2017 and august 2017. Saved that data into two separate QVD files july.qvd & august.qvd.

As also i saved entire 2 months data into single qvd file as Details.qvd

now i have 3 qvd files

july.qvd

august.qvd

Details.qvd

all the qvd files contains date, no.of sales, total amount, profit, loss.

Details.qvd:

Date,no.of sales, total amount, profit, loss

july.qvd:

july_date, july_no.of sales, july_total amount, july_profit, loss


similarly for august.qvd

And i am loading only Details.qvd

i need to create a report contains 2 tables for july and august

how can i make the july_date as dimension separately from details.qvd (this file contains both july & august data)

thanks,

1 Solution

Accepted Solutions
jayshrinipurte
Partner
Partner

hi vivetha,

You can use calculated dimenion as

If(WildMatch(Date,'July 2017'),'July 2017')

Regards,

Jayshri

View solution in original post

3 Replies
jayshrinipurte
Partner
Partner

hi vivetha,

You can use calculated dimenion as

If(WildMatch(Date,'July 2017'),'July 2017')

Regards,

Jayshri

View solution in original post

petter
Partner
Partner

You can keep all the data in one table in your data model but filter the data when you create your visualizations (reports). Make sure that you create a calculated field when creating the Details.qvd or when reading the Details.qvd.

Month( Date ) AS Month  // In a load statement in the data load editor

or

Make it in the Data Manager.

Normally if using the Data Manager it would create an automatic calendar where the Month would be calculated for you.

The way for example to only get July could be:

Dimension: Date

Measure: Sum( {1<Month={'July'}>} Sales}

The bolded portion of the measure is called a set expression that can be used to specifically filter data from the data model and override the current selections of the user's selections.

anat
Specialist
Specialist

Hi ,

use dimension like :Month( Date)

Expression is:Sum( {<Month={'July'}>} Sales}