topic Re: One Slider for different Products in QlikView

One Slider for different Products

Thu, 30 Jan 2014 18:49:23 GMT

Hi All,

I am trying to get the below scenario work,

Lets say I have 3 different product types and I calculate the total cost(for each product) and total cost of all products and display them in a text box. Now I want to choose a particular product using the list box and should have one slider with a variable to increase the sale count of the product selected and see the estimated value of the total cost for each and all products.

TotalCostof All Products = (AverageIncomeoftheProduct1 * CountIncrease)+(AverageIncomeoftheProduct2 * CountIncrease)+(AverageIncomeoftheProduct3 * CountIncrease)

AverageIncomeoftheProduct= TotalIncome/No of units sold

Since I have 1 slider and 1 variable how would I make sure the variable is set to the correct product so the total cost is increased by only the product chosen.

I am using set analysis on the product type in my expressions.

Thanks

Re: One Slider for different Products

Thu, 30 Jan 2014 19:17:11 GMT

Hey,

Please check out the attached file and see if it helps you. This is a basic qvw with simple calculations. You can tweak it to your needs.

Hope it guides you in the right direction

Thanks

Re: One Slider for different Products

Thu, 30 Jan 2014 19:35:42 GMT

Thanks for your quick reply.This is closer. But when I choose the product, I still need to see other products in the chart/table with their actual value in both actual and estimated column. Also the variable value adds the same amount to all the products. But I want it to increase only for the selected product.

Re: One Slider for different Products

Thu, 30 Jan 2014 19:37:58 GMT

The way I designed it the slider works as per your request for the text objects. Did you check the way the three text objects were working when a product is selected and you change the slider?

Edit: So you want that feature in the table? Lemme give it a whirl.

Re: One Slider for different Products

Thu, 30 Jan 2014 19:54:21 GMT

I do see it. But how about displaying the total of all the products in the text even though I choose a product?

Re: Re: One Slider for different Products

Thu, 30 Jan 2014 20:01:03 GMT

How about this one.

Re: Re: Re: One Slider for different Products

Thu, 30 Jan 2014 21:14:51 GMT

I get it. But lets do this, I added count to the sample you did and changed the slider to increase the count.

Attaching the modified sample. I may be complicating the scenario but this is how exactly I would need to produce.

I did not modify the texts that display the total cost and the individual products.

Re: Re: One Slider for different Products

Thu, 30 Jan 2014 21:23:30 GMT

I used the below formula in the Ball text box

=(sum({<Product={'Ball'}>}Amount)/sum({<Product={'Ball'}>}Pcount)) //Average value

*(sum({<Product={'Ball'}>}Pcount)+
if(GetFieldSelections(Product)='Ball',$(vCount),0)) // Original count+Slider Increment

The logic is AverageValue*(Original count+Increased Count)

Re: Re: Re: Re: One Slider for different Products

Thu, 30 Jan 2014 21:34:02 GMT

Fixed it. This should meet your needs. The table works as per your wish.

Lemme know your thoughts

Re: Re: Re: One Slider for different Products

Thu, 30 Jan 2014 21:47:50 GMT

Here is the final QVW

Re: Re: Re: Re: One Slider for different Products

Fri, 31 Jan 2014 15:28:50 GMT

Hi Ajay,

Your qvw works except the total number in the text is incorrect. Also I changed the Estimated total in the chart to sum(expressions) and it works fine. However when I do that in my application, it is not working. If I put set analysis in the product count to ignore the Product selection, the values become null. Not sure waht could be the issue?

I appreciate your help.

Thanks

Re: Re: Re: Re: One Slider for different Products

Fri, 31 Jan 2014 15:37:15 GMT

Ajay,

The chart works fine. The two issue I have is although I increase the count by 5, it increases to 30.

The total estimated text object incorrect.

Thanks

Re: One Slider for different Products

Fri, 31 Jan 2014 15:56:34 GMT

I think it is a bracket issue. put a bracket around the (entire expression) + variable

Can you provide an example of how you want the total text value to be, please explain with numbers like what are all the amounts and if you change the slider what you want the total to be in the text object.

It would be helpful in answering.

Re: Re: One Slider for different Products

Fri, 31 Jan 2014 17:00:58 GMT

I found the issue with incorrect count. Attaching the file with the estimated count. If you select bike and have the slider at 7, then the estimated count shows 16 (since there are 2 bikes)=2(actual count)+7*2. The issue is using the sum for vCount with the set analysis. So instead of the set analysis I tried,

[Actual Count]+if(GetFieldSelections(Product),$(vCount),0)

But the numbers show just the actual count.

Also have you experienced Garbage after Expression errors while using GetFieldSelections. So I used function trim inside the GetFieldSelections. But when I change the count it does not affect the chart anymore.

The Product Names I have has space and special characters in them.

Re: Re: One Slider for different Products

Fri, 31 Jan 2014 17:19:39 GMT

Estimated count seems to be working good in the file you attached
You can't use Getfieldselections in the table. It wont give you the results you are looking for
You can use it in the text object though. Try using " " or [ ] . Just play around and one of them should click

EDIT : I tried if(GetFieldSelections(Product)='Bell &Ball',$(vCount),0) and it worked fine (I just created a field value like Bell &Ball to test)

Re: Re: One Slider for different Products

Fri, 31 Jan 2014 18:32:05 GMT

Thank you. Your posts help me to progress.Will keep you posted on the result