Set Analysis Issue

[QlikAngel]

Hi,

I am using this code in chart

=(Count({$<TC_StockEntryDate={">=$(v_StockEntryDate)<=$(v_StockEndDate)"}>}DISTINCT TC_Stock_ID))

but value is not coming. if i use same logic in IF statement then output getting correctly.

please suggest..

[stigchel · Accepted solution]

You may need the date function, try with

=(Count({$<TC_StockEntryDate={">=$(=Date(v_StockEntryDate))<=$(=Date(v_StockEndDate))"}>}DISTINCT TC_Stock_ID))

[MK_QSL]

may be your variable date format is different than your TC_StockEntryDatedate format.

[QlikAngel]

Nopes date formates are same..

[jonathandienst]

I suggest that you post your qvw or an example qvw that illustrates the problem, otherwise all the suggestions are guesses. Check these:

• Do you variables return the values you are expecting?
• Are they in the correct date format?

Also post the expression that does work. And try these:

=Count({$<TC_StockEntryDate={">=$(=v_StockEntryDate)<=$(=v_StockEndDate)"}>}DISTINCT TC_Stock_ID)

=Count({$<TC_StockEntryDate = {">=$(=Date(v_StockEntryDate))<=$(=Date(v_StockEndDate))"}>} DISTINCT TC_Stock_ID)

[QlikAngel]

Thank you Piet Hein... its so simple...

[stigchel]

You're welcome Mayuri, one other tip for this kind of debugging is to leave the label of the expression blank. In a table it will display the evaluated expression in the header, so you can check whether the variables are giving you the expected values. In e.g. a line chart it will show in the mouse over.

[QlikAngel]

Yup got it .. it will really helpful