Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sarasmonu
Creator
Creator

Metric Value not Displaying as expected

Hi Team,

I have a Dimension and the corresponding metric is Sum({< SubmitDate = {">=$(=Date(effectiveDate))"}>}MetrologyRequest).

I see that only if the Dimension value is selected, the measure for the selected dimension is displayed else every dimension value shows as 0. Please let me know why is that happenng

Thanks,

Monu

2 Replies
ogautier62
Specialist II
Specialist II

Hi,

what is not displayed as expected ?

could you attach a copy screen ?

regards

Gysbert_Wassenaar

The set of a set analysis expression is calculated at the chart level. At that level Date(effectiveDate) cannot return a result, because there are multiple possible values of effectiveDate. Only when you make a selection that results in only one possible effectiveDate value will you get a result. What you're problably trying to do is compare SubmitDate with effectiveDate for each row in your chart: sum(If(SubmitDate >= Date(effectiveDate), MetrologyRequest)). If both fields exists in the same table in your data model then you could create a flag field in that table and then use that field in your set analysis expression:

LOAD

     ...lots of fields....,

     SubmitDate,

     effectiveDate,

     If(SubmitDate >= effectiveDate, 1, 0 ) as SubmitLargerEffective

FROM

     ....

sum({<SubmitLargerEffective={1}>}MetrologyRequest)


talk is cheap, supply exceeds demand