Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table of which fields are : Tdate, location, party and sales%.
I have two conditions:
[Description : For a party find out the number of different Tdate on which sales% is greater than the entered sales% in variable vSales on month basis.]
[Description : For a party find out the vNos percentage of the total number of Tdates on month basis.]
vSales and vNos are two input variables.
My requirement is to make a Bar chart which will show the number of 'party's having the value of condition 1 is greater than condition 2 of different 'location's on monthly basis.
For ready reference I am attaching a qvw and a xls file.
Any help would be highly appreciated.
Thanls & Regards,
Go to Solution.
check this example
hope its helps you
Thanks a lot liron baram. This is the exact result which I was looking for.