Discussion Board for collaboration on QlikView Scripting.
Im new to qlikview
i tried to make a Straight Table but couldn't make it
need your help !!!!
what you are trying to achieve by the straight table.
How did you get the happy sad face column
based on which condition u want that images
it's an assignment need to be done as is in the picture
sum of 2011,2010
column of year 2011 vs 2010 and also in %
and last column adding pic that indicates if there is positive or negative growth
create one new expression with the condition required.
expand the options of expression.Backgroud color->definition->select images tab.
Here u can find all the smiley symbols.
Hope this helps.
I can't open your file (I'm at home)
But I never knew there was an option to have a face in QV. And can't find it
im in a bigger problem
i cant deal with the basics of this tabele
like how do i show year only 2011
and how do i compare them
n the script u can create one new field with condition that year=2011.
So that u can use that field in the chart.
If(Year = 2011) as Year_1
So that we can use Year_1 in chart so that it will show only year 2011