topic Re: Desighn issue in QlikView

Desighn issue

Sat, 15 Feb 2014 20:58:58 GMT

Hi,

requirement is like want to show today sales by default and client want to show historical data if he clicks only then on particular product.

by default it may be pivot table showing today sales.Any body have better suggestion.

regards

Mahesh T

Re: Desighn issue

aveeeeeee7en — Sat, 15 Feb 2014 22:50:32 GMT

Hi Mahesh

Please see the Attached Qvw.

Hope the Solution works for you.

Regards

Aviral Nag

Re: Desighn issue

Sun, 16 Feb 2014 06:55:27 GMT

i am unable to view QVW.Can you please post the screen shot.

regards

Mahesh T

Re: Re: Desighn issue

aveeeeeee7en — Sun, 16 Feb 2014 07:39:21 GMT

PFA.

Re: Desighn issue

Sun, 16 Feb 2014 08:00:13 GMT

Share screen shots not QVWfiles.

regards

Mahesh

Re: Re: Desighn issue

aveeeeeee7en — Sun, 16 Feb 2014 08:16:08 GMT

Check this out.

Re: Desighn issue

Sun, 16 Feb 2014 08:23:06 GMT

Thank very much for spending time for me.

regards

Mahesh T

Re: Desighn issue

stevedark — Sun, 16 Feb 2014 08:26:33 GMT

You could use a conditional show based on the number of possible values.

Firstly you would have a table, or pivot, with Product in the dimension list and an expression like this:

=sum({<Date={'$(=today())'}>}Sales)

And on this chart you would have a Show Condition and Calculation Condition of:

=GetPossibleCount(Sales) > 1

You can then make a copy of this chart (so it is exactly the same size and position as the first chart) and make the following changes.

On the dimensions remove Product and add Date as a dimension.

Change the expression to read:

=sum(Sales).

Change the Show Condition and Calculation Condition to be:

=GetPossibleCount(Sales) = 1

That should give you what you are after. From a UI perspective the images uploaded by Nag Aviral are fine.

I often swap from a table view listing many items (such as products) to a number of objects showing details for many products when there is only one product available. Almost the opposite of what you are asking to do here.

Hope that helps.

Steve

Re: Desighn issue

Sun, 16 Feb 2014 09:12:26 GMT

put Condition like this For Expression like

in Condtional expression u will get your results

GetselectedCount(Product)> 0