# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
New Contributor II

## Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Hello Friends,

Need some help with Set Analysis!!

I am trying to compute the QTD Value for a measure. I have created it as a Master item. I need it to compute for the current quarter. I have variables defined which give the current quarter. I have referenced these variables in the Master item. But for some reason if I pull the Master item in a table it displays only 0.

This is the formula in my Master item

Sum({\$<Year=, Quarter=, Month=, [Cal Quarter Number]={\$(vCurrentQtr)}, [Cal Month Number]={"<=\$(vCurrentPeriod)"}>} [Reported Sales])/1000

This is the table without the measure which shows the right values

This is the table with the measure which shows the 0 values

Tags (3)
1 Solution

Accepted Solutions
MVP

## Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

I think you don't have any data for Reported ACV when quarter number = 77

5 Replies
New Contributor II

## Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Can someone help on this please?

MVP

## Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Would you be able to share your app with us?

New Contributor II

## Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Hi Sunny,

Attached is the qvf file.

Thanks!

MVP

## Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

I think you don't have any data for Reported ACV when quarter number = 77

New Contributor II

## Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Hi Sunny,

You are right! It was indeed an issue with the dataset.

Thanks!