topic Ignore Selections in Mini Chart in QlikView

Ignore Selections in Mini Chart

Tue, 13 Dec 2011 19:16:14 GMT

Hi,

I have to make a Mini chart ignore YearQuarter selections.

I am working on a Mini chart which should display the Trend for all values ignoring YearQuarter selections. I have 5 KPI's, each with a set analysis expression where I have ignored YearQuarter selections. However, for some reason Trend in the Mini chart changes when I make a YearQuarter selection.

Please let me know if there is something wrong with the expression or if there is any other solution.

Here is the expression for Mini chart and please find qvw attached as well-

If(KPICode = '1', COUNT( {$< QuoteStatus = {'WON'}, YearQuarter=>} QuoteLineItemID ) /Count({$< QuoteStatus=, YearQuarter= >} QuoteLineItemID),

If(KPICode = '2', Sum({$< QuoteStatus = {'WON'}, YearQuarter=>} Revenue ) /Sum({$< QuoteStatus=, YearQuarter= >} Revenue),

If(KPICode = '3', Sum({$< YearQuarter= >}(Revenue))/sum({$< YearQuarter= >}(TargetPrice*Quantity)),

if(KPICode = '4', Sum({$< YearQuarter=, QuoteStatus= >} ResponseTime)/COUNT({$< QuoteStatus=, YearQuarter= >} QuoteLineItemID),

Avg({$< YearQuarter= >}DistiMargin)))))

Ignore Selections in Mini Chart

vgutkovsky — Tue, 13 Dec 2011 20:48:10 GMT

Your expression is actually correct, the problem is with your data model. If you mouse over YearQuarter in the table viewer, you will see that it's only at 4% information density in the dates dimension table. You need this to be at 100%. I recommend creating YearQuarter in the script as follows:

year(Date) & '-Q' & ceil(month(num#(Date))/3) as YearQuarter

This should fix the problem I think.

Regards,

Vlad

Re: Ignore Selections in Mini Chart

phcaptjim — Wed, 28 Aug 2013 12:19:17 GMT

Perhaps I am wrong, but I don't think Set Analysis works correctly on MINI charts?

I have been unable to get them to work properly. Perhaps I'm doing something wrong?

Here is my expression:

Num(Sum({<FiscalYear=,FiscalQuarterYear=,FiscalMonthYearName=,MetricDate=>}Numerator),FormatCode)

The dimension for the mini chart is:

FiscalMonthYearName

When a user makes a selection on FiscalMonthYearName, the mini chart changes to reflect that selection. My data model is good (all calendar values are at 100% density).