topic Re: Selections on list box and calendar in QlikView

Selections on list box and calendar

Anonymous — Thu, 13 Aug 2015 05:26:59 GMT

!Hi All,

I have been struggling with this for hours .upon continuous investigations with my problem i could find out few causes for my problem .

I have list box and calendar object.

List box has value Day,MTD,Ytd

Calendar object Sales_date

My requirement is upon selecting particular date i need to know ytd,mtd and day values for that particular date .

Lets Assume i need to find net sales for particular date i.e 2/2/1014.

First i select date and any value from list box (any of the value mtd,ytd,day) then i get the desired result .

for the same date with out changing the date value ,if i select any of list box value then values is the calendar is getting clear.

I need calendar shouldn't be cleared .

Please find the attachment

Re: Selections on list box and calendar

vardhancse — Thu, 13 Aug 2015 05:29:40 GMT

Hi,

You don't want to clear the selection in calendar. that is what you are expecting.?

Re: Selections on list box and calendar

Anonymous — Thu, 13 Aug 2015 05:34:24 GMT

Yes !!

I dont want to clear the selections in calendar.I want the same date(what ever i selected ) should be displayed if i select mtd,ytd,day.

Thanks

Re: Selections on list box and calendar

vardhancse — Thu, 13 Aug 2015 05:54:18 GMT

If you dont want to pass the selections from the list box to the calendar, then create one alternate state and assign to the list box and to the object you want to see the selections pass.

So that filters from list box will pass only to that object with same alternate state.

Re: Selections on list box and calendar

Anonymous — Thu, 13 Aug 2015 06:03:23 GMT

But i need to fetch data for that particular date with respect to mtd or ytd or day.

will it work ?

Re: Selections on list box and calendar

svenkita — Thu, 13 Aug 2015 06:12:49 GMT

If you have a look at you data

DATE_KEY in Fct_Sales is listed

eg : 20150802

and DATE_KEY in the Cal_TimeGranule is

eg: 41638 in the Julian format

Try Changing you Fct_Sales so that the DATE_Key is represented in the same format that should solve your issue.

Re: Selections on list box and calendar

Anonymous — Thu, 13 Aug 2015 06:21:44 GMT

I tried but i problem is not resolved.

Re: Selections on list box and calendar

Anonymous — Thu, 13 Aug 2015 06:22:23 GMT

I tried with alternate states .It's not working

Thanks

Re: Selections on list box and calendar

Anonymous — Thu, 13 Aug 2015 07:04:03 GMT

I have changed as per your suggestions.

Now my calendar is not getting cleared .but i can get data for only any one list box selection value.(either mtd or ytd or day)

Re: Selections on list box and calendar

Anonymous — Thu, 13 Aug 2015 09:54:00 GMT

Hi All,

My selection is not getting applied on CY_GROSSSALES which is in fct_sales.

Re: Selections on list box and calendar

svenkita — Thu, 13 Aug 2015 23:56:06 GMT

I started a new file and did a binary load of your file and had the changes done to the script ... the selections do not get deselected.

try it out.. i am unable to attach the file due to the size.

SCRIPT

---------

Binary ;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='D/MM/YYYY';

SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

NoConcatenate

CAL1:

Load * Resident CAL;

Drop Table CAL;

NoConcatenate

Cal_TimeGranule1:

Load DATE_KEY, Num, TempDate, TimeGranule Resident Cal_TimeGranule;

Drop Table Cal_TimeGranule;

NoConcatenate

Fct_Sales1:

Load Num(Date(Date#(DATE_KEY,'YYYYMMDD'),'YYYYMMDD')) as DATE_KEY, CAL_DATE, CY_GROSS_SALES Resident Fct_Sales;

Drop Table Fct_Sales;

Re: Selections on list box and calendar

Anonymous — Fri, 14 Aug 2015 06:28:26 GMT

Thanks Subharaman !!!

i'll check with the script .

Thanks alot

Re: Selections on list box and calendar

svenkita — Fri, 14 Aug 2015 08:10:55 GMT

could you reduce the size of your file by loading data only for 6 months and have it attached. I will make the changes and send back

Re: Selections on list box and calendar

Anonymous — Fri, 14 Aug 2015 09:41:03 GMT

Subraman

I have attached qvw with one month data.Please find the attachment in question of this discussion.

Thanks

Re: Selections on list box and calendar

svenkita — Fri, 14 Aug 2015 12:25:01 GMT

If you look at your data in the fact table there is only one date available. all the transactions are of 07/01/2014

any way i have worked on the model using sample data and changed the model for you

the whole thing is done using data islands and depending on what you select

MTD

YTD

DAY

the formula in the text field will change according.

Hope this helps

Re: Selections on list box and calendar

Anonymous — Fri, 14 Aug 2015 13:16:22 GMT

Thanks alot for your time.

I have tried the application.But set expression seems to be not working fine .

i tried the below the expression its throwing error

If(TimeGranule='DAY',sum({<DATE_KEY={$(=Only(Star_Date))}>}CY_GROSS_SALES))

thanks

Re: Selections on list box and calendar

svenkita — Fri, 14 Aug 2015 13:30:51 GMT

i have added a new text with the formula

the new text is yellow

Re: Selections on list box and calendar

svenkita — Fri, 14 Aug 2015 13:34:28 GMT

sorry there was an issue in the file i have re attached the file kindly download and check

Re: Selections on list box and calendar

Anonymous — Sat, 15 Aug 2015 10:38:58 GMT

Thanks a ton subraman