topic Re: Set Analysis Issue in QlikView

Set Analysis Issue

QlikAngel — Thu, 02 Jul 2015 09:58:07 GMT

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

Re: Set Analysis Issue

stigchel — Thu, 02 Jul 2015 10:02:54 GMT

You may need the date function, try with

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

Re: Set Analysis Issue

MK_QSL — Thu, 02 Jul 2015 10:03:33 GMT

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

Re: Set Analysis Issue

QlikAngel — Thu, 02 Jul 2015 10:05:37 GMT

Nopes date formates are same..

Re: Set Analysis Issue

jonathandienst — Thu, 02 Jul 2015 10:06:35 GMT

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)

Re: Set Analysis Issue

QlikAngel — Thu, 02 Jul 2015 10:12:02 GMT

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

Re: Set Analysis Issue

stigchel — Thu, 02 Jul 2015 10:18:37 GMT

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.

Re: Set Analysis Issue

QlikAngel — Thu, 02 Jul 2015 10:38:22 GMT

Yup got it .. it will really helpful