topic Re: Need Help in QlikView

Need Help

help4qv123 — Thu, 08 Dec 2016 10:40:07 GMT

Hi Friends,

I need a help for cumulated month selection and mtd month selection.

There is a txt object which switches form YTD to MTD.

(For Ytd all month and for mtd single month.)

When YTD is (Switched )selected All the months till the selected month should be selected.

(If I select Jun the selection should be from Jan to Jun)

Again when switched form YTD to MTD then for Mtd Only june should be selected.

When switched from YTD to MTD

Please see the sample attached,.

Re: Need Help

sunny_talwar — Thu, 08 Dec 2016 10:58:31 GMT

Check the attached

I used a select in field action

=If(Vtest = 'MTD', '(' & Concat({<MonthNum = {"<=$(=Max(MonthNum))"}, Month>} Month, '|') & ')', '(' & Concat({<MonthNum = {"$(=Max(MonthNum))"}, Month>} Month, '|') & ')')

Where MonthNum is created in the script like this

LOAD Month(Date#(Month, 'MMM')) as Month,

Num(Month(Date#(Month, 'MMM'))) as MonthNum,

Data

FROM

[test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: Need Help

help4qv123 — Thu, 08 Dec 2016 11:12:24 GMT

Hi sunny Thanks for this.

But its just working on switching from MTD to YTD.

After switching form Mtd To YTD it shows. when i change the month selection form june to march or some other the cumulation of months should also effect that.

For example,June is selected in MTD and then when switched to YTD it selects from Jan to June.

When i change month selection suppose september then the same should effect on the month selection.

Means selection form Jan to Sep.

Thanks i Advance

Re: Need Help

help4qv123 — Thu, 08 Dec 2016 12:06:01 GMT

Hi Sunny any clue on this

Re: Need Help

sasikanth — Thu, 08 Dec 2016 12:12:56 GMT

try this

Use Filed level trigger

Please check the attched application for reference

Re: Need Help

sunny_talwar — Thu, 08 Dec 2016 12:13:31 GMT

You might be able to do this, but I would recommend you against it because it is going to make your application very very complicated. I would suggest you to look into The As-Of Table‌ for the YTD information display. This will keep your application simple and without unnecessary triggers

Re: Need Help

sunny_talwar — Thu, 08 Dec 2016 12:27:12 GMT

Check the attached

Re: Need Help

help4qv123 — Thu, 08 Dec 2016 12:29:37 GMT

Thanks sasi. My app does not have date and your expression looks too big

Re: Need Help

help4qv123 — Thu, 08 Dec 2016 12:33:53 GMT

Ok i will check with this. I have made it but its too complicated and makes effect on performance. Thats the reson i am taking the help of you experts.

The sample which you have sent is Good. thanks for that.

I also want to do it with simple trigger. I will try that.