topic Re: Set Analysis to select all months in Quarter in QlikView

Set Analysis to select all months in Quarter

Thu, 04 Feb 2016 20:44:44 GMT

I have a requirement to display all values falling within the quarter when any month within the quarter is selected in filters. So if the user selects the month of May, they should see sales from all of Q2. Can anyone help me adjust the syntax of the below (or provide an alternate solution if necessary)?

sum({<SaleQtr = p({<SaleMonth = {$(=GetFieldSelections(SaleMonth))}>} SaleQtr)>} sale_amount)

I have tried several variations on the above with no success so far.

Thanks

Re: Set Analysis to select all months in Quarter

sunny_talwar — Thu, 04 Feb 2016 20:46:36 GMT

May be this:

Sum({<SaleQtr = p(SaleQtr), SaleMonth>} sale_amount)

Re: Set Analysis to select all months in Quarter

fcecconi — Thu, 04 Feb 2016 21:29:20 GMT

Ashley

I use a master calendar and set a QTD flag based on a date in the calendar table. It will get refreshed with each load.

I use -InQuarterToDate(Datum, Today(),0) as CQTD_Flag,

Datum is autogenerated date.

Hope this helps

Re: Set Analysis to select all months in Quarter

Mon, 08 Feb 2016 20:30:31 GMT

Sorry, that doesn't appear to be valid syntax for set analysis, and I can't quite figure out what you're suggesting well enough to adjust it.

Re: Set Analysis to select all months in Quarter

Mon, 08 Feb 2016 20:32:29 GMT

I think i see what you're suggesting here, but my need is for it to be dynamic based on the user selection. If the user selects August, I need it to show all of Q3, if they select Feb, it should show Q1, etc. Or is there a way to adapt your suggestion to what I'm looking for? Sorry if I'm just not seeing it.

Re: Set Analysis to select all months in Quarter

sunny_talwar — Mon, 08 Feb 2016 20:34:32 GMT

I am suggesting to ignore the selection made in SaleMonth field, but because of the selection made in SaleMonth we would have made a indirect selection in SaleQtr. So take everything for the SaleQtr (SaleQtr = p(SaleQtr)) part.

Re: Set Analysis to select all months in Quarter

Mon, 08 Feb 2016 20:43:38 GMT

Thanks, but after much more trial and error, I have come up with the solution - sort of similar to your suggestion.

I created a variable using =concat(SaleQtr,',') to make a list of possible quarters, then use that in the set analysis:

{<SaleQtr = {$(=$(vSaleQtrs))}, SaleMonth = >}

This produces the desired result.

Re: Set Analysis to select all months in Quarter

sunny_talwar — Mon, 08 Feb 2016 20:45:56 GMT

Glad you did, but I would suggest you to at least try it out once. I find p() to be a cleaner way of doing it + you might learn something new .

Best,

Sunny

Re: Set Analysis to select all months in Quarter

Mon, 08 Feb 2016 20:47:48 GMT

Thanks, I did try the p() route in every possible configuration i could think of but it did not produce the desired behavior in my app.

Re: Set Analysis to select all months in Quarter

sunny_talwar — Mon, 08 Feb 2016 20:54:28 GMT

Here is an example to look at