Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

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 - Creator
Partner - Creator

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 - Creator
Partner - Creator

hi vivetha,

You can use calculated dimenion as

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

Regards,

Jayshri

petter
Partner - Champion III
Partner - Champion III

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
Master
Master

Hi ,

use dimension like :Month( Date)

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