topic Re: Set Analysis is not working properly in QlikView

Set Analysis is not working properly

Anonymous — Thu, 21 Jan 2016 12:54:05 GMT

Hi,

I have created 2 straight tables to compare the data of selected year and its previous year.

In first table I am showing the previous year data using the below condition in set analysis for year->

Year = {$(=GetFieldSelections(Year)-1)}

And in 2nd table I am using -> Year = {$(=GetFieldSelections(Year))} in set analysis.

When I am selecting any year, in 1st table it shows proper data of selected year but in 2nd table it shows only its total at the top. I have sorted the column in descending order but still it is not showing any data in the table except total.

I am attaching the screen shot.

can anyone please help me on this?

- Poonam

Re: Set Analysis is not working properly

sunny_talwar — Thu, 21 Jan 2016 18:12:29 GMT

Can you share the complete expression? and there is nothing to see even when you scroll down?

Re: Set Analysis is not working properly

Thu, 21 Jan 2016 18:18:24 GMT

Hi Poonam, could you attach the .qvw file?

If the straight table it's the same, only with condition of year & year -1, it's strange!

Attach the file please for that I can help you !

Regards

Re: Set Analysis is not working properly

Thu, 21 Jan 2016 18:24:24 GMT

Hi Pooman, I think..

Try this:

Year = {$(=GetFieldSelections(Year))}-1

Re: Set Analysis is not working properly

Anonymous — Fri, 22 Jan 2016 07:07:24 GMT

Hi Leira,

Thanks for your help.

But still it is not working

-Poonam

Re: Set Analysis is not working properly

Anonymous — Fri, 22 Jan 2016 07:15:25 GMT

Hi,

I am attaching the QVW file.

-Poonam

Re: Set Analysis is not working properly

sunny_talwar — Fri, 22 Jan 2016 11:27:27 GMT

Check it out now

The actual issue was the you were multiplying your expressions with a field and that was not having the Year - 1 set analysis. So as soon as you selected a year that particular part of the expression didn't know how to handle the multiplication. Not sure how the Total worked. but adding the same set analysis to the field fixed the issue on all three of your expressions.

Re: Set Analysis is not working properly

sasikanth — Fri, 22 Jan 2016 11:43:41 GMT

HI,

Try like,

Year= {$(=max(Year)-1)}

= sum({<Stage ={'S','L','D','Q'}, Year = {$(=max(Year)-1)},

[Closure Reason]={'*'}-{'Admin Error','D-Admin Error or Duplicate value', 'Opportunity Consolidation or Duplicate Value', 'D-Oppty Consolidation'}>}

([Booking Amount Euros] *[Change Rate Value] ))

Re: Set Analysis is not working properly

Mahamed_Qlik — Fri, 22 Jan 2016 11:46:36 GMT

Hi Poonam,

If your trying to comparison of data between two duration of time then better you go with the Alternate State.

Here you will get the info about the Alternate State.

About Alternate state.

Hope it will help.

Regards,

Mahamed

Re: Set Analysis is not working properly

Anonymous — Fri, 22 Jan 2016 13:51:09 GMT

Hi Sunny,

Great!! It is working now. Thank you so much for your help

That means the main idea is if we are performing multiplication in the expression then for 2nd expression also we need to apply set analysis?

But how it was working for 1st table(current selected year)?

-Poonam

Re: Set Analysis is not working properly

sunny_talwar — Fri, 22 Jan 2016 14:43:21 GMT

Because you were still wanting to see the selected year's information in the above table. Problem is related to selection here. When you are selecting a particular year, you cannot see last year without using set analysis.

Re: Set Analysis is not working properly

Anonymous — Fri, 22 Jan 2016 20:21:17 GMT

Hi Sunny,

Got it now Thanks for the explanation.

- Poonam