Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi To Every One........
Can You Please clarify me Difference between set analysis and Alternate states.....Actually i am little bit confusion about that..............
Hi,
The various methods for optimized load are:
Try to create QVD files. By creating QVD files u can have 90% compressed data of original one
which can save lot of memory.
Eliminate if statements as much as possible, instead u can use flags.
Don't write complex expressions at the front end, try to write more script at the back end.
And avoid synthetic keys by creating link tables or by renaming the fields.
There was a similar request just recently:
Alternate states is used for comparative analysis of data for different years or quarters using charts.
Selections made in one state or not reflected in another state in alternate states.
Alternate states - The Developer can create multiple states within a QlikView document and then apply these states to specific objects within the document.
Ex: - This feature can be utilized to compare multiple groups of, for example, sales. It is also useful to compare selected products vs the rest of the products.
Set analysis is used to analyze data as whole or subset, in set analysis selections are reflected among all charts and controls in sheets.
Set analysis can be used in Alternate states.
Hi Nuthankumar.........
Thanks for your replay...........
The purpose of alternate states and set analysis is provides the comparative analysis for Qv Objects.Alternate states is better so why we go for set analysis................and what are the major difference between them....Can you please help me.........
Hi,
The purpose of alternate states and set analysis is not the same. They are different.
Alternate states is used for comparative analysis. The Qv designer can create multiple states within a Qv document and apply these states to specific objects. Now the objects which are assigned particular states, that object will respond to user selections which are made in that particular state only.
And about set analysis. Set analysis allows you to define exactly which data we would like the expression to use.
For example:
=Sum({$<Country={'USA'}>}LineSalesAmount)
Here we have specified USA as a country which means your chart should use USA only. If you select country UK or any other. the chart will not respond to user selection rather it will display values related USA itself.
Hi sowmya..........
Thanx for your explanation.Now i get clear clarification.........
And One more Question Can you Give me the some of optimized Techniques for Qlikview project Development(Dash board design,memory Savings........) with some explanations?
Hi,
The various methods for optimized load are:
Try to create QVD files. By creating QVD files u can have 90% compressed data of original one
which can save lot of memory.
Eliminate if statements as much as possible, instead u can use flags.
Don't write complex expressions at the front end, try to write more script at the back end.
And avoid synthetic keys by creating link tables or by renaming the fields.
Dear Chandini,
Set Analysis
Defining a set of field values is referred to as defining a set expression and using set expressions to analyze data is referred to as set analysis.
Alternate States
You can use Alternate States to perform comparative analysis between sets of multiple data items, for example for basket analysis purposes. A state holds a set of selections.
Key point: Alternate States functionality is not accessible in the load script.
Kind regards,
Ishfaque Ahmed
Hi....
How we can eliminate if statements instead using of Flags?Can you explain with example?
Set Analysis:
Is used to write expressions for the metrics
There will be some conditions based on that we can write the set analysis:
Set analysis will not work in the script level
It will work only in the chart expression,list box simply to say only in the fornt end UI objects
Alternate States:
Alternate state is the option in QV:
We can do comparitive analysis
the selections we do will pass only to the objects of same alternate states